How to Add Multiple Records in a Table ?
Answer : We can also insert multiple records (more than one) records into a table by using INSERT INTO Statement.
Syntax :
INSERT INTO table_name (column1, column2, column3)
VALUES
(value1, value2, value3),
(value1, value2, value3),
(value1, value2, value3);
Suppose we have an Employees table and want to insert 3 records into the table:
INSERT INTO Employees (Employee_ID, Employee_Name, Salary)
VALUES
(101, ‘Anjali’, 50000.50),
(102, ‘Priya’, 45000.75),
(103, ‘Amit’, 55000.00);
| Employee_ID | Employee_Name | Salary |
|---|---|---|
| 101 | Anjali | 50000.50 |
| 102 | Priya | 45000.75 |
| 103 | Amit | 55000.00 |
