SQL Data Manipulation Statement: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
A [[SQL Data Manipulation Statement]] is a [[Data Manipulation Statement]] within a [[SQL language]]. | A [[SQL Data Manipulation Statement]] is a [[Data Manipulation Statement]] that is a [[SQL statement]] (within a [[SQL language]]). | ||
* <B>Context:</B> | * <B>Context:</B> | ||
** It can range from being a [[SQL INSERT Statement]], to being a [[SQL UPDATE Statement]] to being a [[SQL DELETE Statement]]. | ** It can range from being a [[SQL INSERT Statement]], to being a [[SQL UPDATE Statement]] to being a [[SQL DELETE Statement]]. |
Revision as of 01:36, 28 June 2013
A SQL Data Manipulation Statement is a Data Manipulation Statement that is a SQL 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):
- See: SQL Data Definition Statement.