Description
The SQL keyword VALUES is used to specify the values for an INSERT INTO statement.
- It can be used to specify values for a single record insert statement.
- It can also be used to specify values for a multiple records insert statement.
INSERT Single Record
The below SQL inserts a single record into a table.
INSERT INTO employees (employee_name, gender, birth_date, hire_date, salary)
VALUES ('John Jacobs', 'M', '1996-10-21', '2015-11-10', 63000);INSERT Multiple Records
The below SQL inserts multiple records with a single INSERT statement, where the values for each record are separated with a comma.
INSERT INTO employees (employee_name, gender, birth_date, hire_date, salary)
VALUES
('Harry Potter', 'M', '1998-05-21', '2017-18-08', 52000),
('Jerry Thomas', 'F', '2001-08-25', '2019-07-07', 49000),
('Alice Conner', 'F', '1999-12-10', '2015-04-04', 55000);