Data Manipulation Language

Data Manipulation Language (DML)

Introduction

Data Manipulation Language (DML) is a subset of SQL used to manipulate data in a database.

DML Commands

• INSERT: Used to add new data to a table.
• UPDATE: Used to modify existing data in a table.
• DELETE: Used to delete data from a table.

INSERT Command

• INSERT INTO: Used to add new rows to a table.
• VALUES: Specifies the values to be inserted into the table.

UPDATE Command

• UPDATE: Used to modify existing rows in a table.
• SET: Specifies the columns to be updated and their new values.
• WHERE: Specifies the conditions for which rows to update.

DELETE Command

• DELETE FROM: Used to delete rows from a table.
• WHERE: Specifies the conditions for which rows to delete.

Importance of DML

• Data Modification: DML is used to modify data in a database.
• Data Maintenance: DML is used to maintain the accuracy and relevance of data in a database.
• Data Management: DML is an essential tool for managing data in a database.