SQL Insert INTO Query

The SQL INSERT INTO query used to insert one OR more records to a table in the database.

SQL INSERT INTO syntax

To insert the values for the specific columns in the table:

INSERT INTO table_name ('column1', 'column2', 'column3'...)
VALUES ('value1', 'value2', 'value3',...);

To insert the values for all the column in the table:

INSERT INTO table_name
VALUES ('value1', 'value2', 'value3',...);

Important Description

• The number of columns and values must be the same.
• If a column is not specified, the default value for the column is used in SQL INSERT INTO query.
• The values specified by the INSERT statement must satisfy all the applicable constraints including (primary keys, CHECK constraints, and NOT NULL constraints), etc.
• If a syntax error occurs, the new row is not added to the table.

Employee Table

A sample of EMPLOYEE records table & the name of table Employee. The column(s) of the Employee table [ID, EMPLOYEE_NAME, EMPLOYEE_EMAIL, ADDRESS, CITY, and COUNTRY]:

INSERT INTO Query Example

INSERT INTO Employee (EMPLOYEE_NAME, EMPLOYEE_EMAIL, ADDRESS, CITY, COUNTRY')
VALUES ('Permila L', 'pl@gmail.com', '49 Cross Road', 'Mumbai', 'India');