โ
๐ค AโZ of SQL Commands ๐๏ธ๐ปโก
A โ ALTER
Modify an existing table structure (add/modify/drop columns).
B โ BEGIN
Start a transaction block.
C โ CREATE
Create database objects like tables, views, indexes.
D โ DELETE
Remove records from a table.
E โ EXISTS
Check if a subquery returns any rows.
F โ FETCH
Retrieve rows from a cursor.
G โ GRANT
Give privileges to users.
H โ HAVING
Filter aggregated results (used with GROUP BY).
I โ INSERT
Add new records into a table.
J โ JOIN
Combine rows from two or more tables.
K โ KEY (PRIMARY KEY / FOREIGN KEY)
Define constraints for uniqueness and relationships.
L โ LIMIT
Restrict number of rows returned (MySQL/PostgreSQL).
M โ MERGE
Insert/update data conditionally (mainly in SQL Server/Oracle).
N โ NULL
Represents missing or unknown data.
O โ ORDER BY
Sort query results.
P โ PROCEDURE
Stored program in the database.
Q โ QUERY
Request for data (general SQL statement).
R โ ROLLBACK
Undo changes in a transaction.
S โ SELECT
Retrieve data from tables.
T โ TRUNCATE
Remove all records from a table quickly.
U โ UPDATE
Modify existing records.
V โ VIEW
Virtual table based on a query.
W โ WHERE
Filter records based on conditions.
X โ XML PATH
Generate XML output (mainly SQL Server).
Y โ YEAR()
Extract year from a date.
Z โ ZONE (AT TIME ZONE)
Convert datetime to specific time zone.
โค๏ธ Double Tap for More
Post #2326
1.43K
- โค 2