 | DDL | DML |
|---|---|---|
| Commands Behaviour | Auto-committed, i.e. it saves all the changes permanently in the database. | Not auto-committed. It means changes are not permanent to database, they can be rolled back. |
| Stands for | Data Definition Language | Data Manipulation Language |
| Example | CREATE, ALTER, DROP, TRUNCATE, COMMENT.RENAME | INSERT, UPDATE, MODIFY, SELECT, DELETE, MERGE, CALL |
| Related To | Defining data | Inserting, Deleting, Reviving, and Modifying data |
| Uses | Used for defining the data structures, especially database schemas | Used for data manipulation of data structures |
Add content for DDL vs. DML or review and improve the comparison table above.