SQL Commands and their Categories in MySql

SQL language commands/statements and are categorized into following five groups:

• DQL: Data Query Language(SELECT)
• DDL: Data Definition Language(CREATE, DROP, TRUNCATE, ALTER)
• DML: Data Manipulation Language(DELETE, INSERT, UPDATE)
• DCL: Data Control Language(GRANT, REVOKE)
• TCL: Transaction Control Language(COMMIT,ROLLBACK, SAVEPOINT,SET TRANSACTION)

In the next tutorials we will go into more details about them.