Data manipulation language

 

Data manipulation language (DML) describes the portion of SQL that manipulates or controls data.

• Retrieving data using the SELECT statement
  The SELECT statement tailors your query to gather data. You can use the SELECT statement to retrieve a specific row or retrieve data in a specific way.

• Inserting rows using the INSERT statement
  To add a single row or multiple rows to a table or view, use a form of the INSERT statement.

• Changing data in a table using the UPDATE statement
  To update data in a table or view, use the UPDATE statement.

• Removing rows from a table using the DELETE statement
  To remove rows from a table, use the DELETE statement.

• Using subqueries
  You can use subqueries in a search condition as another way to select data. Subqueries can be used anywhere an expression can be used.

 

Parent topic:

SQL programming

 

Related concepts

Types of SQL statements