php mysql插入1000万行_php操作mysql迅速插入上百万数据

建表

用户表

CREATE TABLE `user` (

`id` BIGINT (20),

`name` VARCHAR(20)

)ENGINE=INNODB;

日志表

CREATE TABLE `log` (

`id` BIGINT (20),

`msg` VARCHAR(20)

)ENGINE=INNODB;

ini_set('max_execution_time', '0');//mysql执行时间

@mysql_pconnect("localhost","root","ziguangruanjian") or die('connect failed');

@mysql_select_db("tiantian") or die('select db failed');

//这一步很重要 取消mysql的自动提交

mysql_query('SET AUTOCOMMIT=0;');

mysql_query('set names utf8');

$begin = time();

$count = 1;

for($i=1;$i<=1000000;$i++){

mysql_query("insert into user values($i,'name')");

//插入20W提交一次

if($i%200000=='0'){

$count++;

mysql_query("insert into log values($i,$count)");

mysql_query("commit");

}

}

$end = time();

echo "用时 ".($end-$begin)." 秒

---

";

?>