Data Manipulation Language (DML)


Data Manipulation Language (DML) includes commands within the SQL language used for manipulating objects in a database.

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