update table set column= case id when 1 then value1 when 2 then value2 end where id in(1,2)
转载于:https://www.cnblogs.com/didiaoge/p/10979270.html
update table set column= case id when 1 then value1 when 2 then value2 end where id in(1,2)
转载于:https://www.cnblogs.com/didiaoge/p/10979270.html