Insert multiple records in a single query
To insert multiple records in a single query, each record is enclosed in parentheses and is separated by a comma. Here is the syntax of inserting multiple records in a single query.
INSERT INTOtable_name (column1, column2, column3, etc…) VALUES (value1, value2, value3, etc…), (value1, value2, value3, etc…), (value1, value3, value3, etc…);
We have here an example of inserting multiple records in a single query:
INSERT INTO employee_record (f_name, l_name, position, age, salary, email) VALUES (“Sam”, “Milby”, “System Analyst”, 34, 20000, “email@example.com”), (“John Lloyd”, “Cruz”, “Network Administrator”, 33, 20000,”firstname.lastname@example.org”);
Once you have encoded the command correctly, it will display a success message.
Ex. Query OK, 1 row affected (0.00 sec)
Note: using this technique will make your work faster and it will improve the processing performance of your database.