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);

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles:

©2023 Copyright DevX - All Rights Reserved. Registration or use of this site constitutes acceptance of our Terms of Service and Privacy Policy.

Sitemap