INSERT INTO - Used to add new rows to the table.

The syntax of SQL INSERT INTO

Using the enumeration values, indicating the column:

1

INSERT INTO  ([, ... ]) VALUES (,...)

Using the list of values, without specifying the columns:

1

INSERT INTO  VALUES (,...)

In the latter case, the table can insert more than one record. If the table has other fields requiring fill, but not specified in the statement insert, Then for them to be installed with a default or null, if the default is not installed.

Example

Is the following table "Persons":

Now we add a new row in the table "Persons".

Using the following SQL query:

1
2

INSERT INTO Persons
VALUES (4,'Nilsen', 'Johan', 'Bakken 2', 'Stavanger')

Now the table "Persons" has the following form:

Inserting the data only in a special column

SQL provides the ability to insert data into the needed columns.

The following SQL query to add a new row, but the data will be contained only in the columns "P_Id", "LastName" и "FirstName":

1
2

INSERT INTO Persons (P_Id, LastName, FirstName)
VALUES (5, 'Tjessem', 'Jakob')

Now the table "Persons" has the following form: