Computer Science, asked by tiwarichanda985, 1 year ago

Differences between DDL and DML commands.
Please give answer in ur own words

Answers

Answered by Anaya5432
1
DDL means data description language and and DML means data manipulation language it manipulates the data
common statements of DDL are drop, alter
common statements of DML Are delete and insert
Answered by aariztkhan
1

Apart from the full form

DDL is used to define the structure of a database which basically means editing or creating the structure of the database. So the commands which do this are:

"CREATE" is command used to create a new Database or Table.

"ALTER" command is used to change(alter) the content in the Table.

"DROP" is used to delete SELECTED content in the database or table.

"TRUNCATE" is used to delete ALL the content from the table.

"RENAME" is used to rename the content in the database.

DML is used to RETRIEVE data from the database that you created. So its like fulfilling the main purpose of your database LOL.

Commands are SELECT,DELETE,UPDATE,INSERT.


tiwarichanda985: this answer is from Google
aariztkhan: YEA i didnt know this one
aariztkhan: i tried my best to elaborate though
tiwarichanda985: it's okay
Similar questions