Question

Define DML.

Hint:

Remember the difference: DDL (Data Definition Language like `CREATE`, `ALTER`) defines the structure of the database, while DML (Data Manipulation Language) manages the data inside that structure.

Answer 1

DML stands for Data Manipulation Language. It is a subset of SQL (Structured Query Language) used for adding, deleting, and modifying data in a database. DML commands are used to manage the data within the tables. The primary DML commands are:

SELECT: Retrieves data from one or more tables.
INSERT: Adds new rows of data into a table.
UPDATE: Modifies existing data within a table.
DELETE: Removes existing rows from a table.