SQL INSERT Statement

The SQL INSERT statement is used to insert a single or multiple data in a table. In SQL, You can insert the data in two ways:

  1. Without specifying column name
  2. By specifying column name

Sample Table

EMPLOYEE

EMP_IDEMP_NAMECITYSALARYAGE
1AngelinaChicago20000030
2RobertAustin30000026
3ChristianDenver10000042
4KristenWashington50000029
5RussellLos angels20000036

1. Without specifying column name

If you want to specify all column values, you can specify or ignore the column values.

Syntax

Query

Output: After executing this query, the EMPLOYEE table will look like:

EMP_IDEMP_NAMECITYSALARYAGE
1AngelinaChicago20000030
2RobertAustin30000026
3ChristianDenver10000042
4KristenWashington50000029
5RussellLos angels20000036
6MarryCanada60000048

2. By specifying column name

To insert partial column values, you must have to specify the column names.

Syntax

Query

Output: After executing this query, the table will look like:

EMP_IDEMP_NAMECITYSALARYAGE
1AngelinaChicago20000030
2RobertAustin30000026
3ChristianDenver10000042
4KristenWashington50000029
5RussellLos angels20000036
6MarryCanada60000048
7Jacknullnull40

Note: In SQL INSERT query, if you add values for all columns then there is no need to specify the column name. But, you must be sure that you are entering the values in the same order as the column exists.


Next TopicDBMS SQL Update