SQL Data Manipulation Statement

A SQL Data Manipulation Statement is a Data Manipulation Statement within a SQL language.

• Context:
  • It can range from being a SQL INSERT Statement, to being a SQL UPDATE Statement to being a SQL DELETE Statement.
• Example(s):
  • SELECT * INTO ...
  • a MySQL Data Manipulation Statement, such as:
    • LOAD DATA LOCAL INFILE '/path/data.txt' INTO TABLE pet LINES TERMINATED BY '\r\n';
  • a HiveQL Data Manipulation Statement.
  • UPDATE table_one t1 JOIN (SELECT DISTINCT id FROM table2) t2 ON t1.id=t2.id SET t1.flag=1 WHERE pm.value='yes' ;
  • DELETE FROM t1 WHERE id IN (value1, value2, value3, value4, value5);
• Counter-Example(s):
  • a SQL Data Querying Statement.
  • a Hash Data Manipulation Statement.
• See: SQL Data Definition Statement.

---

---