Data Manipulation (DML) Syntax

Data Manipulation Syntax

Insert:

{ INSERT } INTO tablePrimary
[ '(' column [, column ]* ')' ]
[ VALUES '(' column [, column ]* ')' ]           

 

Update:

>

UPDATE tablePrimary
SET assign [, assign ]*
[ WHERE booleanExpression ]			

 

Delete:

>

DELETE FROM tablePrimary [ [ AS ] alias ]
[ WHERE booleanExpression ]

 

Explain:

>

EXPLAIN PLAN
   FOR { query }
EXPLAIN ANALYZE
   FOR { query }