SQL INSERT Statement

SQL Insert command is used to save record into a database in a specific table.

The SQL Insert command has the following syntax:

Now considering the following table.

Users:

Now if we want to insert a new record to the table we can write the SQL statement as:

Then the table will be like

Users:

We can also insert data in the table by simply passing the values and not mentioning the column names, but this technique requires that all values must be provided for all columns with respective positions as the column name.

For example:

This statements insert the data as 1st value for 1st column 2nd value for 2nd column , 3rd value for 3rd column and so on.

Users:

If we accidently or willingly write the insert statement as:

Then there will a column mismatch error and the data will not be added to the table, because the DBMS expects that all values must be provided when no column names are mentioned.

To insert partial data in the table one can write the SQL insert statement by writing the column names and there values.

For example, if we wish to add the first name, last name and country of a person then we can write the insert statement as:

Then the data will be inserted in the table successfully by putting a Null value in place of the column to which we did not entered values. See example at the last row of the following table.

Users:

This kind of SQL insert statement only works when null values are allowed in the table structure, if null values are not allowed then an error will occur during the insert.