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

See also  5 Ways to Improve Customer Experience
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

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