Laravel 数据库批量更新的问题，请大家帮我看看！感谢！

可以使用case when拼接来批量更新

 public static function updateBatch(array $attributes = [])
    {
        try {
            $tableName = self::TABLE;
            $firstRow = current($attributes);
            $columns = array_keys($firstRow);

            $referenceColumn = isset($firstRow['id']) ? 'id' : current($columns);
            unset($columns[0]);
            // 拼接sql语句
            $updateSql = "UPDATE ".$tableName." SET ";
            $sets = [];
            $bindings = [];
            foreach ($columns as $column) {
                $setSql = "`".$column."` = CASE ";
                foreach ($attributes as $data) {
                    $setSql .= "WHEN `".$referenceColumn."` = ? THEN ? ";
                    $bindings[] = $data[$referenceColumn];
                    $bindings[] = $data[$column];
                }
                $setSql .= "ELSE `".$column."` END ";
                $sets[] = $setSql;
            }
            $updateSql .= implode(', ', $sets);
            $whereIn = collect($attributes)->pluck($referenceColumn)->values()->all();
            $bindings = array_merge($bindings, $whereIn);
            $whereIn = rtrim(str_repeat('?,', count($whereIn)), ',');
            $updateSql = rtrim($updateSql, ", ")." WHERE `".$referenceColumn."` IN (".$whereIn.")";

            return DB::update($updateSql, $bindings);
        } catch (\Exception $exception) {
            return false;
        }
    }

使用示例

$lists = [];
$lists[] = [
  'id'=>1,
  'name'=>'test',  
];

ProductItem::updateBatch($lists);