作者kalecgos0616 (.)
看板Database
标题[SQL ] 合并多句UPDATE的SQL
时间Mon Nov 1 15:43:00 2010
资料库是MySQL 5.0.27
现在我要执行两句sql
UPDATE Table SET Amount =20 WHERE Id =1
UPDATE Table SET Amount =10 WHERE Id =2
我希望能像DELETE能做到
DELETE FROM Table WHERE Id = 1
DELETE FROM Table WHERE Id = 2
可以合并成
DELETE FROM Table WHERE Id IN (1, 2)这样一句去执行
请问要怎麽写呢？
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.125.41.241
1F：→ ninetyeight:update栏位的值不一样...无法这样合并 11/01 17:07
2F：推 cspy:update table set Amount=(if(id-1=0,'20','10')); 11/01 19:20
3F：推 cspy:如果Id有限定{1,2} 可以这样写XD 11/01 19:36