不解释,直接上代码
$connect_mysql->autocommit(false); mysqli_query($connect_mysql,'set names utf8'); $begin = time(); $sqls =''; for($i=1;$i<=100000;$i++){ $sqls .= "('....','.....','.....'),"; if($i%10000=='0'){ $sql = 'INSERT INTO `table` (`field1`,`field2`,`field3`) value'.rtrim($sqls, ","); mysqli_query($connect_mysql,$sql); $sqls =''; unset($sql); } } $end = time(); echo "用时 ".($end-$begin)." 秒 <hr/>";