首页 > 数据库技术 > 详细

批量插入数据 mysql

时间:2017-08-20 11:48:54      阅读:237      评论:0      收藏:0      [点我收藏+]
        $sql = "INSERT INTO `fenqi`.`sdfq_customer_order` (
                    `order_sn`,order_status,customer_id,remark,price,need_price,create_time,fenqi_type_id,fenqi_num_id,buiness_area_id
                    )VALUES";
        $sqle = "";
        for ($i = 20001; $i <= 40000; $i++) {
            $sqle .= "(" . setOrderNumber() . ",2,$i,ramark" . $i . ",20000,20000," . fqdate() . ",4,7,270),";

//        $sql = substr($sql, 0, strlen($sql) - 1);
            if ($i % 1000 == 0) {
                $sqle = rtrim($sqle, ",");
                $dosql = $sql . $sqle;
                Db::execute($dosql);
                $sqle = "";
            }
        }

 

批量插入数据 mysql

原文:http://www.cnblogs.com/clearsice/p/7399250.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!