php 插入百万数据

//在MySQL命令行中输入此语句 set global max_allowed_packet = 2*1024*1024*10;

/*$sql = "insert into phone (field1,field2) values";

//然后sql语句拼接
for($i=1;$i<=1000000;$i++){

    $sql .= "('value1','value2'),";
}

//去掉字符串最后的逗号 ","
$sql = substr($sql,0,strlen($sql)-1);

//执行sql语句
Db::query($sql);*/