SQL Data Manipulation Language (DML)

What is Data Manipulation Language (DML) in SQL

Data manipulation language (DML) is used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML.

The most important Data Manipulation Language (DML) statements in SQL are given bellow:

• SELECT

               – The Select Statement is used to extracts data from a database table

• UPDATE

               – The Update Statement is used to update the data in a database table

• DELETE

               – The Delete Statement is used to delete the data from a database table

• INSERT INTO

               – The Insert Statement inserts new data into a database table


Most of the SQL Queries are common across all the database systems. We will learn more about each SQL Statements and how to use these statements in our SQL Queries in next sessions.

Previous Chapter - DML and DDL in SQL

Next Chapter - SQL Data Definition Language (DDL)

SHARE