Data Definition Language (DDL):
CREATE: Used to create database objects like tables, indexes, or views.
ALTER: Modifies the structure of existing database objects.
DROP: Deletes database objects like tables or indexes.
Data Manipulation Language (DML):
SELECT: Retrieves data from one or more tables.
INSERT: Adds new rows of data into a table.
UPDATE: Modifies existing data in a table.
DELETE: Removes rows from a table.
Data Control Language (DCL):
GRANT: Provides specific privileges to database users.
REVOKE: Removes specific privileges from database users.
Transaction Control Language (TCL):
COMMIT: Saves all changes made during the current transaction.
ROLLBACK: Undoes changes made during the current transaction.
SAVEPOINT: Sets a point within a transaction to which you can later roll back.
4 окт 2024