Skip to main content

SQL Command Types

Learn SQL Command Types (MySQL Topics, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

SQL commands are grouped into 4 categories based on what they do: DDL (Data Definition Language) - defines structure: CREATE, ALTER, DROP DML (Data Manipulation Language) - works with data: SELECT, INSERT, UPDATE, DELETE DCL (Data Control Language) - manages permissions: GRANT, REVOKE TCL (Transaction Control Language) - manages transactions: COMMIT, ROLLBACK

More lessons in MySQL Topics