The BNF notations for DML statements follow:
INSERT INTO <table_or_view_name>
[(<column_name>,...)]
{{VALUES (<literal> |
<expression> |
NULL |
DEFAULT,...)} |
{<select_statement>} }
UPDATE <table_or_view_name>
SET {<column_name> = <literal> |
<expression> |
<single_row_select_statement> |
NULL |
DEFAULT,...}
[WHERE <predicate>]
DELETE FROM <table_or_view_name> WHERE <predicate>