This is an old revision of the document!

SQL - Cheat Sheet - Categories

DDL	Data Definition Language
DQL	Data Query Language
DML	Data Manipulation Language
DCL	Data Control Language
TCL	Transaction Control Language

Commands

CREATE | DROP | ALTER | TRUNCATE | RENAME | COMMENT

SELECT

INSERT | UPDATE | DELETE | LOCK | CALL | EXPLAIN PLAIN

GRANT | REVOKE

COMMIT | ROLLBACK | SAVEPOINT | SET TRANSACTION

CREATE TABLE Students (
  rollno INT PRIMARY KEY,
  fname VARCHAR (255) NOT NULL,
  lname VARCHAR (255)
);