A Practical Guide to SQL and Database Fundamentals/

...

/

Data Manipulation Language (DML)

Data Manipulation Language (DML)

Learn the commands to add, modify, and remove the table data.

We'll cover the following...

Data Manipulation Language (DML) is precisely what it sounds like; it manipulates the data. These statements are part of DML and allow us to modify existing data, create new data, or even delete it.

Note: DML is not specific to objects like modifying a table’s structure or a database’s settings but works with the data in the tables.

The three data manipulation statements are:

  • INSERT
  • UPDATE
  • DELETE

The following sections ...