Data Manipulation Language (DML)
Data Manipulation Language (DML) includes commands within the SQL language used for manipulating objects in a database.
- inserts, updates, and deletes data
- can be used alongside other languages, such as Transaction Control Language (TCL)
- MySQL documentation: Data Manipulation Statements
- e.g.,
INSERT INTO City
VALUES (100, 'Geneva', 206000);DML Commands
SELECT- select fields from table(s) to view or use
UPDATE- update field data
INSERT- insert values from other tables
DELETE- delete records based on criteria