Question

SQL中怎么修改满足条件的多条记录的同个属性的值

表table_1
id task name
8 aaa
9 632 bbb
10 ccc
11 65 ddd
12 eee
修改成
表table_1
id task name
8 455 aaa
9 632 bbb
10 785 ccc
11 65 ddd
12 214 eee
并且
455,785,214这些要插入的数据已经知道,该怎么写语句呀? 请指教

Answer 1

如果考虑SQL性能就这样吧
update table_1
set task = (case when id = 8 then 455
when id = 10 then 785
when id = 12 then 214 end)
where id = 8 or id = 10 or id = 12

Answer 2

update table_1
set task=(case id when 8 then 455
when 10 then 758
when 12 then 214
....
end)