话不多说,直接上代码:
<?php
//先本地生成模拟数据写入文件
set_time_limit(1000);
$times = time();
$myFile = "f:/www/insert.sql";
$fhandler = fopen($myFile, 'wb');
if ($fhandler) {
$i = 18;
while ($i < 1000000) {
++$i;
$time = $times + $i;
//插入数据时以\t分隔每个字段的值
$sql = $i . "\tThis is a test url\t".$time."\t1";
fwrite($fhandler, $sql . "\r\n");
}
}
/*
最后在命令行执行如下命令:
LOAD DATA LOCAL INFILE 'f:/www/insert.sql' INTO TABLE `test_use_qrcode` (`id`, `url`, `add_time`, `status`);
*/
?>