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.and 
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)?

Sumit Kesarwani

Can you answer this question?

2 Answers

Liked By