Summary of SQL statement classification

Data Definition Language DDL

Create DATABASE db_name;

CREATE TABLE table_name (column_name data_type,...);

CREATE VIEW view_name as SELECT ...;

CREATE INDEX on table_name (column_name,...);

Drop database db_name;

DROP TABLE table_name;

Drop View view_name;

Drop index table_name.index_name; (Different SQL dialect, this is the SQL Server notation)

ALTER TABLE TABLE_NAME

Add column_name data_type

Drop column_name;

Change column_name new_column_name data_type,...

Modify COLUMN_NAME data_type,...

Data Manipulation Language DML

Select column_name from table_name where ...

UPDATE table_name set Column_name=value where ...

INSERT INTO table_name (cloumn_name,...) VALUES (value1,...)

Delete from table_name where ...

Data Control Language DCL: Control permissions

Grant Select,updat,insert,delete on table_name to [email protected]_name;

Revoke SELECT,UPDAT,INSERT,DELETE on table_name to [email protected]_name;

Transaction Control Language TCL: Control transaction

Commit

Rollback

Summary of SQL statement classification