Laravel 4:在1个请求中运行多个更新查询

Laravel 4: run multiple update query in 1 request

本文关键字：运行更新查询请求 1个 Laravel | 更新日期: 2023-09-27

在Laravel、中，有没有任何方法可以在单个连接中运行多个更新查询

update users set score = score+130 where id = 12;
update users set score = score+10 where id = 10;
update users set score = score+10 where id = 14;

DB::update("
    update users set score = score+130 where id = 12;
    update users set score = score+10 where id = 10;
    update users set score = score+10 where id = 14;
");

您的案例可以通过两个查询来解决：

DB::table('users')->where('id', 12)->increment('score', 130);
DB::table('users')->whereIn('id', [10, 14])->increment('score', 10);