Inserting Multiple Records in Mysql Code in Single query
Most of the cases we are using for loop to insert multiple records in a table. This will cause increase in execution time. So the best way is to avoid the looping. This example will help you to insert multiple records to MySQL table in Single query.
insert into students (student_name, age) values
('Michalka', '26'),
('Mockingbird', '18'),
('John', '23')
