What is DML (Data Manipulation Language)?

Question

Aryan Kumar · Answer

In SQL (Structured Query Language), Data Manipulation Language (DML) is a subset of SQL statements used to manipulate data in a database. DML commands are used to add, modify, delete, and retrieve data from a database table.

The most common DML commands in SQL are:

SELECT - used to retrieve data from a table.
INSERT - used to insert new data into a table.
UPDATE - used to modify existing data in a table.
DELETE - used to delete data from a table.

Here's a brief explanation of each DML command:

SELECT: The SELECT command is used to retrieve data from a table. It allows you to specify which columns to retrieve, which rows to retrieve, and how to sort the data.
INSERT: The INSERT command is used to add new data to a table. It allows you to specify which columns to insert data into and what values to insert.
UPDATE: The UPDATE command is used to modify existing data in a table. It allows you to specify which columns to update, which rows to update, and what values to use.
DELETE: The DELETE command is used to remove data from a table. It allows you to specify which rows to delete based on certain conditions.

In summary, DML commands are used to manipulate data in a database table. They allow you to add, modify, delete, and retrieve data from a table.

Sumit Kesarwani · Answer

This language that enable user to access or manipulate data as organised by appropriate data model.

Procedural DML or Low level: DML requires a user to specify what data are needed and how to get those data.

Non-Procedural DML or High level: DML requires a user to specify what data are needed without specifying how to get those data.

interview

What is DML (Data Manipulation Language)?

Can you answer this question?

2 Answers