How to do a batch insert in MySQL

Question

I have 1-many number of records that need to be entered into a table. 

What is the best way to do this in a query?

Should I just make a loop and insert one record per iteration? Or is there a better way?

Answer 1

You can try out the following query:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);