mysql模拟插入1000万数据

<?php
date_default_timezone_set("PRC");
$t = time();
set_time_limit(1000);
$myFile="user.sql";
$fhandler=fopen($myFile,'wb');
if($fhandler){
    $sql="268\t2\t'0,262,268,'\t0\t '2342'\t'423423'\t'123123'\t'23423423'\t'2012-01-09 09:55:43'\t'upload/product/20111205153432_53211.jpg'\t'upload/product/thumb_20111205153432_53211.jpg'\tNULL\tNULL\t38\t'件'\t''\t123\t123\t0";
    $i=0;
    while($i<1000000)//1,000,000
    {
        $i++;
        fwrite($fhandler,$sql."\r\n");
    }
    echo"写入成功,耗时:",time()-$t;
}
//重复运行几次即可

 

posted @ 2017-07-18 21:02  yuancr  阅读(707)  评论(0)    收藏  举报