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:
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 | New Delhi | 28 | 3000 |
6 | Huang | Beijing | 28 | 2800 |
-
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
❮ SQL Keywords