douhuan1497
2013-03-18 10:33
浏览 154
已采纳

将海量数据插入Mysql数据库的最快方法[重复]

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?

</div>

图片转代码服务由CSDN问答提供 功能建议

此问题已经存在 这里有一个答案:</ p>

  • 如何尽快将2000万条记录插入MySql数据库 4 answers </ span> </ li> </ ul> </ div>

    I 实际上有一个100,000条记录的列表,我想插入MySQL数据库。</ p>

    我试图用 foreach </ code>和简单的插入它们 INSERT INTO </ code>然而,插入甚至100行需要花费大量时间。 像1秒/行一样。</ p>

    是否有任何方法可以更快地插入这些行?</ p> </ div>

6条回答 默认 最新

相关推荐 更多相似问题