Question

Briefly describe the four basic SQL DML statements and explain their uses.​

Answer 1

DML [Data Manipulation Commands] commands are those commands that deal with the altering of data present in the table or rather, as the name suggests, commands used for manipulating data.

The four basic DML commands are as follows:

• Delete
• Insert into
• Select
• Update

1. Delete

• Delete is used to delete records from a table.

Syntax: DELETE FROM <table_name> WHERE <condition>;

2. Insert into

• Insert into is used to insert values/records into a table.

Syntax: INSERT INTO <table_name> VALUES(<value1>, <value2>, <value3>, ... );

3. Select

• Select is used to display data/retrieve data from the table.

Syntax: SELECT <*/column_name/function> FROM <table_name> WHERE <condition>;

4. Update

• Update is used to modify existing data in a table.

Syntax: UPDATE <table_name> SET <column_name> = <new_value> WHERE <condition>;