SQL Multiple Insert

SQL Multiple Insert,/b> is used a multiple entries in one go.

Syntax


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



Example

INSERT INTO Student(`RollNo`, `Name`, `Class`) VALUES ('45', 'Rahul', 'Class 12');
INSERT INTO Student(`RollNo`, `Name`, `Class`) VALUES ('46', 'Karan', 'Class 12');
INSERT INTO Student(`RollNo`, `Name`, `Class`) VALUES ('47', 'Ajay', 'Class 12');

Back To Top