我需要更新 postgresql 資料庫中單列中的多行
我有這個：
UPDATE tableA
SET
column_a = CASE WHEN column_a = 'conserve' THEN column_a = 'fixed',
column_a = CASE WHEN column_a = 'balance' THEN column_a = 'moderate',
column_a = CASE WHEN column_a = 'balance growth' THEN column_a = 'moderate growth',
column_a = CASE WHEN column_a = 'aggressive' THEN column_a = 'moderate/agressive';
但出現語法錯誤
Error: syntax error at or near ","
uj5u.com熱心網友回復：
你可以用一個CASE陳述句來做到這一點：
UPDATE tableA
SET
column_a = CASE WHEN column_a = 'conserve' THEN 'fixed'
WHEN column_a = 'balance' THEN 'moderate'
WHEN column_a = 'balance growth' THEN 'moderate growth'
WHEN column_a = 'aggressive' THEN 'moderate/agressive'
END;
在這里試試。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/476013.html
標籤：sql PostgreSQL sql更新