INSERT Multiple Rows in MySQL

Insert Many Rows at Once

INSERT INTO students (roll_no, name, marks) VALUES
(1, 'Aman', 88),
(2, 'Riya', 91),
(3, 'Karan', 76);

INSERT ... SELECT

Copy rows from one table into another:

INSERT INTO toppers (name, marks)
SELECT name, marks FROM students WHERE marks >= 90;

Summary

• List multiple value groups separated by commas for bulk insert.
• INSERT ... SELECT copies matching rows from another table.

एक साथ कई Rows Insert करें

INSERT INTO students (roll_no, name, marks) VALUES
(1, 'Aman', 88),
(2, 'Riya', 91),
(3, 'Karan', 76);

INSERT ... SELECT

एक table से rows दूसरी में copy करें:

INSERT INTO toppers (name, marks)
SELECT name, marks FROM students WHERE marks >= 90;

सारांश

• Bulk insert के लिए comma से कई value groups लिखें।
• INSERT ... SELECT दूसरी table से matching rows copy करता है।