Data Manipulation Language

Read this chapter and take notes on the purpose and use of the clause SELECT and how the INSERT and DELETE statements are used to make changes to data. Also, note how functions are used in these statements.

SQL Data Manipulation Language

The SQL data manipulation language (DML) is used to query and modify database data. In this chapter, we will describe how to use the SELECT, INSERT, UPDATE, and DELETE SQL DML command statements, defined below.

  • SELECT  – to query data in the database
  • INSERT  – to insert data into a table
  • UPDATE – to update data in a table
  • DELETE – to delete data from a table

In the SQL DML statement:

  • Each clause in a statement should begin on a new line.
  • The beginning of each clause should line up with the beginning of other clauses.
  • If a clause has several parts, they should appear on separate lines and be indented under the start of the clause to show the relationship.
  • Upper case letters are used to represent reserved words.
  • Lower case letters are used to represent user-defined words.

Source: Adrienne Watt and Nelson Eng, https://opentextbc.ca/dbdesign01/chapter/chapter-sql-dml/
Creative Commons License This work is licensed under a Creative Commons Attribution 4.0 License.