Data Manipulation Statement

A Data Manipulation Statement is a programming statement (expressed in a data manipulation language) that is intended to add, update and delete data.

• Context:
  • It can be a Data Load Statement.
  • It can be a Data Insert Statement.
  • It can be a Data Update Statement.
  • It can be a Data Delete Statement.
• Example(s):
  • a SQL Data Manipulation Statement, such as a SQL DELETE Statement or a SQL INSERT Statement, or a SQL UPDATE Statement.
  • a HiveQL Data Manipulation Statement, such as HiveQL LOAD DATA Statement.
  • …
• Counter-Example(s):
  • a Data Querying Statement.
  • a Data Definition Statement.
• See: Data Structure, Hash Structure Manipulation Statement, Data Access Statement.

---

---

References

2012

• http://en.wikipedia.org/wiki/Data_manipulation_language
  • A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML.

    A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database. Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

    Data manipulation language comprises the SQL data change statements, which modify stored data but not the schema or database objects. Manipulation of persistent database objects, e.g., tables or stored procedures, via the SQL schema statements, rather than the data stored within them, is considered to be part of a separate data definition language. In SQL these two categories are similar in their detailed syntax, data types, expressions etc., but distinct in their overall function.

    Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:

    • SELECT … FROM … WHERE ...
    • INSERT INTO … VALUES ...
    • UPDATE … SET … WHERE ...
    • DELETE FROM … WHERE ...
  • The purely read-only SELECT query statement is classed with the 'SQL-data' statements and so is considered by the standard to be outside of DML. The SELECT … INTO form is considered to be DML because it manipulates (i.e. modifies) data. In common practice though, this distinction is not made and SELECT is widely considered to be part of DML.

• http://en.wikipedia.org/wiki/SQL#Data_manipulation
  • The Data Manipulation Language (DML) is the subset of SQL used to add, update and delete data:

---