INSERT statement is used to add new rows of data to a table. There are two ways to insert record

  • Inserting the data directly to a table.
  • Inserting data to a table through a SELECT statement.


Inserts a single row into an existing table. Specify values for all columns except the AUTO INCREMENT column.

INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,...);
  • table_name is the name of the table from which data is added.
  • Comma separated list of columns in the table surrounded by parentheses.
  • Comma separated list of values surrounded by parentheses in the VALUES clause.

Shorter form of INSERT statement is given below. List of values must have the same order as the list of columns in the table.

INSERT INTO table_name

INSERT statement also allows to insert multiple rows into a table using a single statement.

INSERT INTO table_name(column1,column2…)
VALUES (value1,value2,…),

To copy data from a table to another table, use SELECT statement to select values from another table and supply them to the INSERT statement. List of columns in the SELECT clause must be corresponding to the list of columns in the INSERT INTO clause.

INSERT INTO table_name(column1, column2,...)
     column1, column2,...


/* Insert a row to the employee table */
INSERT INTO employleinfo(id,firstName,lastName,age) VALUES(8,'Om','Singh',1)

/* Inserting data to all the columns, the column names can be omitted */
INSERT INTO employleinfo VALUES(9,'Garima','Singh',30,'Lucknow')


Inserting One or More Rows Into a Table