How to do a batch insert in MySQL

Question

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

What can be the best way to do this in a query?

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

Answer 1

INSERT statements that use VALUES syntax can insert multiple rows into the table. 

To do that, include the multiple lists of column values, each enclosed within parenthesis and separated by commas. 

Refer MySQL manual for more info.

Example:

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

If you want to learn more about SQL, the best online SQL courses by Intellipaat that offers instructor-led training, certification, and job assistance.