php - Quickest way to Insert mass data Into Mysql database -

i have list of 100,000 records i'd insert mysql database.

i have tried insert them foreach , simple insert into took lot of time insert 100 row. 1 second / row.

is there method insert these rows faster?

using 1 insert statement multiple rows faster 1 insert statement per row. reduce calls database.

example:

 insert tbl_name (a,b,c) values(1,2,3),(4,5,6),(7,8,9);