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

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

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.