Update employee set a='a' where b=1
Update employee set a='b' where b=2
……
与
update employee set case when b=1 then a='a' when b=2 then a='b' else a='c'
更新速度一样?
...全文
1065打赏收藏
SQL update case
Update employee set a='a' where b=1 Update employee set a='b' where b=2 …… 与 update employee set case when b=1 then a='a' when b=2 then a='b' else a='c' 更新速度一样?