if ($strleng>100){
//如果大于100条就每次写入100,休息1秒,然后继续写,直到写完为止
$write_count = floor($strleng/100);
while ($write_count > 0){
for ($i=0;$i<100;$i++){
echo "INSERT INTO tbl_name (a,b,c) VALUES(1,2,3)";//写100次就休息
}
//echo "INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);";这样可以一次插入多条数据,效率更高
//参考https://dev.mysql.com/doc/refman/5.7/en/insert.html
$write_count -=1 ;
sleep(1);
echo '休息1秒';
}
}
追问为啥 $write_count -=1 ?