SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.

The INSERT INTO Statement

The INSERT INTO statement is used to insert a new row in a table.

It is possible to write the INSERT INTO statement in two forms.

The first form doesn't specify the column names where the data will be inserted, only their values:

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

The second form specifies both the column names and the values to be inserted:

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

We have the following "Persons" table:

P_Id	LastName	FirstName	Address	City
1	Karmen	Kasa	Los Angels - USA	New Orleans
2	Jacob	Mary	Los Angels - USA	New Orleans
3	Maxwell	Glen	Australia	Sydney

Now we want to insert a new row in the "Persons" table.

We use the following SQL statement:

INSERT INTO Persons
VALUES (4,'Tendulkar', 'Sachin', 'India MH', 'Mumbai')

The "Persons" table will now look like this:

P_Id	LastName	FirstName	Address	City
1	Karmen	Kasa	Los Angels - USA	New Orleans
2	Jacob	Mary	Los Angels - USA	New Orleans
3	Maxwell	Glen	Australia	Sydney
4	Tendulkar	Sachin	India MH	Mumbai

It is also possible to only add data in specific columns.

The Below SQL statement will add a new row, but only add data in the "P_Id", "LastName" and the "FirstName" columns:

INSERT INTO Persons (P_Id, LastName, FirstName)
VALUES (5, 'Laxmi', 'Mary')

The "Persons" table will now look like this:

P_Id	LastName	FirstName	Address	City
1	Karmen	Kasa	Los Angels - USA	New Orleans
2	Jacob	Mary	Los Angels - USA	New Orleans
3	Maxwell	Glen	Australia	Sydney
4	Tendulkar	Sachin	India MH	Mumbai
5	Laxmi	Mary