Data Manipulation Language
Use Data Manipulation Language (DML) of SQL to access and modify database data by using the select, update, insert, delete, truncate, begin, commit, and rollback commands.
When you are using commands to manipulate data, you can use row values. SQL-92 row values are
supported. For
example:
SELECT * FROM emp WHERE (id, name,grp)=(3,'John','sdev');The following table describes the Netezza Performance Server SQL DML.
| Component | Description |
|---|---|
| DELETE | Removes rows from a table. See DELETE. |
| INSERT | Adds new rows to a table. See INSERT. |
| SELECT | Retrieves rows from a table or view. See SELECT (to retrieve rows). |
| TRUNCATE | Empties a table. See TRUNCATE. |
| UPDATE | Replaces values of columns in a table. See UPDATE. |