阅读背景:

如何在没有LOAD DATA INFILE的情况下在MySQL表中插入大量数据?

来源:互联网 

I have a CSV file with around 1.8million rows. I need to insert them into a MySQL table from my PHP script. I am inserting the values in batches of 10,000. The scripts run for very long time and crashes after inserting 80-95 batches. I have tried mysql_unbuffered_query() also but of no use.I have a CSV file with around 1.8million rows.




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: