PHP mysql INSERT一次插入多条表单数据的方法答:sql = "insert into myorder (pid,amount,ordernumber,time,uid,status) VALUES ";foreach ($gouwuche as $k => $v) { sql .= "(".$v['pid'].",".$v['amount'].",'$ordernumber','$time',1,0),";} sql = substr($sql, 0,strlen($sql)-1);把$gouwuche换你购物车里的...
PHP+mysql插入上千万条数据,导致内存不足,寻求释放内存方法答:一次性插入1000条数据比一条一条的插入速度会提升N倍,主要技巧就是在写SQL的上面 insert into table1 value (v1, v2, v3), (x1,x2,x3),...而不是 insert into table1 value (v1, v2, v3);insert into table1 value (x1, x2, x3);...