What is the difference between DDL and DML commands.

Question

In easy and simple language.

Answer 1

DDL - Data Definition Language
The word itself says that it define the structure of the table and database. like Creating table , adding removing columns. etc..
DDL commands are Auto committed

DML - Data Manipulation Language
It deals with the data of the table like insertion of rows and updation 's of values deletion of rows.
Rollback can be done after execution the of the command.

Answer 2

DDL commands are about the structure of thee table itself (create table, nummer of columns...)
DML commands are about the data IN the table (values, insertion of new rows...)

Answer 3

Is Data definition and Data Manipulation only the difference?

Answer 4

ddl means datadefinitionlanugage

Answer 5

dml means datamanupulcationlanugage