SQL VALUES Keyword

The SQL VALUES keyword is used to specify the values of an SQL INSERT INTO statement. There are two ways of using VALUES keyword which are mentioned below:

Syntax

The below syntax specifies column names and respective values to be inserted.

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

The below syntax specifies values only. Therefore, it is essential to specify values in the same order as the columns in the table.

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

Example:

Consider a database tables called Employee with the following records:

• To insert a new record in the Employee table, the SQL query is:

  INSERT INTO Employee (EmpID, Name, City, Age, Salary)
  VALUES (7, 'Suresh', 'Mumbai', 29, 2900);
  
  OR
  
  INSERT INTO Employee 
  VALUES (7, 'Suresh', 'Mumbai', 29, 2900);
  

  
  

  Now the Employee table will contain following records:

  EmpID	Name	City	Age	Salary
  1	John	London	25	3000
  2	Marry	New York	24	2750
  3	Jo	Paris	27	2800
  4	Kim	Amsterdam	30	3100
  5	Ramesh	Mumbai	28	2900
  6	Huang	Beijing	28	2800
  7	Suresh	Mumbai	29	2900

• Insert Data Only in Specified Columns: To insert data in specified columns, it is necessary to specify column names. Please see the SQL code below:

  INSERT INTO Employee (EmpID, Name, Age)
  VALUES (7, 'Suresh', 29);
  

  
  

  Now the Employee table will contain following records:

  EmpID	Name	City	Age	Salary
  1	John	London	25	3000
  2	Marry	New York	24	2750
  3	Jo	Paris	27	2800
  4	Kim	Amsterdam	30	3100
  5	Ramesh	Mumbai	28	2900
  6	Huang	Beijing	28	2800
  7	Suresh	NULL	29	NULL