如何高效使用insert_mysql_10000_data.php批量导入大量数据到MySQL？

本文共计125个文字，预计阅读时间需要1分钟。

phpinsert_mysql_10000_data.phppublic function insert_max() { $res=array(1, 2, 3, ..., 1000000); $step_length=5000; $d_name='达达'; $d_type='book'; $d_url='www.baidu.com'; $time=time(); $step_total=ceil(count($res) / $step_length);}

insert_mysql_10000_data.php

public function insert_max() { $res = array(1, 2, 3, ...., 1000000); // $step_length = 5000; $d_name = '达达'; $d_type = 'book'; $d_url = 'www.baidu.com'; $time = time(); $step_total = ceil (count($res) / $step_length); $num = 0; for ($i=0; $i < $step_total ; $i++) { $sql = "INSERT INTO fds_download (`b_id`, `b_type`, `d_name`, `d_url`, `create_time`) values"; $start = $i*$step_length; $end = ($i+1)*$step_length; if($end > count($res)) { $end = count($res); } for($j=$start; $j<$end; $j++) { $sql .= " (".$res[$j]. ", '".$d_type."', '".$d_name."', '". $d_url."', ".$time."),"; $num++; } $sql = substr($sql, 0, -1); M()->execute($sql); } echo '成功插入:'.$num; }