UPDATE `cos02bo-a`.`currency` SET `value` = '1.00000000' WHERE `code` = 'USD';
UPDATE `cos02bo-a`.`currency` SET `value` = '0.93000000' WHERE `code` = 'EUR';
UPDATE `cos02bo-a`.`currency` SET `value` = '0.82000000' WHERE `code` = 'GBP';
這三條陳述句怎么寫成一條啊
uj5u.com熱心網友回復：
UPDATE `cos02bo-a`.`currency`
SET `value` = CASE WHEN `code`= 'USD' THEN '1.00000000'
WHEN `code`= 'EUR' THEN '0.93000000'
WHEN `code`= 'GBP' THEN '0.82000000'
END
WHERE `code` IN( 'USD','EUR','GBP');
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/38081.html
標籤：應用實例
上一篇：sql server能跨服務器創建表和更新表結構資訊？
下一篇：Python爬蟲爬小說