What is a Data Manipulation Language?

by

Data manipulation language makes the user able to retrieve and manipulate data. It is used to perform the following operations.

  • Insert data into database through INSERT command.
  • Retrieve data from the database through SELECT command.
  • Update data in the database through UPDATE command.
  • Delete data from the database through DELETE command.

In SQL, Data Manipulation Language (DML) is a subset of SQL statements that deals with the manipulation of data stored in a database. The primary operations of DML are:

  1. SELECT: Retrieves data from one or more tables. It is used to query the database and retrieve specific information based on specified criteria.
  2. INSERT: Adds new records (rows) to a table. It is used to insert new data into the database.
  3. UPDATE: Modifies existing records in a table. It is used to update the values of existing data in the database.
  4. DELETE: Removes records from a table. It is used to delete existing data from the database.

These DML operations allow users to interact with and manipulate the data within a database, providing the ability to retrieve, insert, update, and delete data as needed.