LoginSignup
0
0

More than 3 years have passed since last update.

@wo4wanga

laravel实现批量更新多条记录的方法示例

Last updated at Posted at 2021-03-04

用代码实现凭借成下列sql语句即可同时批量更新多条数据
UPDATE table_name SET column = CASE 'id' WHEN 1 THEN ? WHEN 2 THEN ? ELSE column END WHERE id IN (1,2)

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0