This question already has an answer here:
I actually have a list of 100,000 records which I'd like to insert into the MySQL database.
I have tried to insert them with
foreach and simple
INSERT INTO however it took a lot of time to insert even 100 row. Like 1 second / row.
IS there any method to insert these rows much faster?