MySQL/Language/Definitions: what are DDL, DML and DQL?

  • Data Definition Language (DDL): CREATE, ALTER, DROP
  • Data Manipulation Language (DML) INSERT, UPDATE , DELETE
  • Data Query Language (DQL) SELECT, SHOW , HELP
  • Data Control Language (DCL) GRANT , REVOKE
  • Data Transaction Language (DTL) START TRANSACTION, SAVEPOINT, COMMIT , ROLLBACK [TO SAVEPOINT]