Data Manipulation Language (DML) is a subset of SQL used to manage data within database objects created by DDL statements.

Through DML commands like INSERT, UPDATE, DELETE, and MERGE, users can add new records, modify existing data, remove records, and combine data from different sources within the database tables.

DML operations work with the actual data content rather than the database structure, making them essential for day-to-day database operations where data needs to be maintained, updated, or removed according to business requirements. For example, when a customer places an order, DML statements would be used to insert the order details into an orders table and update the inventory levels in a products table.

See also DDL.

Origin: DDL
References:
Created 2025-02-16