devxlogo

INSERT INTO Syntax

INSERT INTO Syntax

Question:
What is the standard SQL-92 syntax for INSERT INTO?

Answer:
Be sure to check your product documentation for any variations! This is standard syntax, but not all products will implement each aspect of the standard, and may include additional extensions.

This is the BNF grammar for the elements related to the INSERT INTO command. (Some of the more obvious definitions were not included for the sake of space?for instance, I’m assuming that the reader will know what

means.)
 ::=    INSERT INTO 
::= [ ] &124; DEFAULT VALUES ::=

Examples:

INSERT INTO Inventory        VALUES ('A102', 'Widget', 431);INSERT INTO Customers (cust_no, name, balance)        VALUES (33892, 'James Thomason', 312.33);

devx-admin

Share the Post: