本文共 489 字,大约阅读时间需要 1 分钟。
public function execute($data, $splitNum) { foreach (array_chunk($data, $splitNum) as $values) { echo insertBatch('tableName', ['字段1', '字段2', '字段3'], $values); } }public function insertBatch($table, $keys, $values) { $tempArray = []; foreach ($values as $value) { $tempArray[] = implode("','", $value); } return "INSERT INTO `".$table."` (`".implode('`,`', $keys)."`) VALUES ('".implode("),(", $tempArray)."')"; }
转载地址:http://sfyws.baihongyu.com/