我正在嘗試更新 sql 中三行的列。但是，當我運行以下查詢時，只有一行受到影響。有人可以幫我看看我在哪里犯了錯誤嗎？謝謝！
update some_table
set date_updated = case some_id
when '7791' then '2021-10-08 06:59:05'
when '1555' then '2021-08-26 05:30:54'
when '363201' then '2021-08-31 05:01:45'
end
where some_id = ('7791, 1555, 363201')
and date_updated between '2021-11-01' and '2021-11-03';
uj5u.com熱心網友回復：
你錯過了IN條款
where some_id in ('7791' ,'1555' , '363201')
and date_updated between '2021-11-01' and '2021-11-03';
uj5u.com熱心網友回復：
update some_table
set date_updated =
case when some_id = '7791' then '2021-10-08 06:59:05'
when some_id = '1555' then '2021-08-26 05:30:54'
when some_id = '363201' then '2021-08-31 05:01:45'
end
where some_id IN ('7791', '1555', '363201')
and date_updated between '2021-11-01' and '2021-11-03';
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/346747.html
上一篇：雪花-日期表過濾問題