PHP MySQL插入行限制

Question

Currently I have a PHP script that inserts about 2000+ rows into the mysql database.

But for my case it stops after 500+ rows. Any idea what could be the issue?

I have verified by also displaying out the data before insertion and it shows all the 2000+ rows of data.

Came across this posting MySQL insert limit? but I am currently using MySQL in Windows.

How could I remove the limit?

Thanks In Advance

Answer 1

This happens because of the time limit exceeding 30 sec.... To overcome this , you can follow either the following steps

1. Use this code 
 set_time_limit(0);
 in your php before inserting into db

or

2. Change the time limit in your php.ini file ...

1 option is better and temperory measure though