我想清理一張桌子，只保留 6 行以 uuid 為目標
DELETE FROM user WHERE user_id!='2536466f-38d0-4e81-acda-2e411fdb3030'
AND user_id!='cefc6515-e4a4-460c-9fb2-eb883037ff9e'
AND user_id!='479acacf-3914-485f-958c-51sfe77e6beb'
AND user_id!='7436a5a6-1361-42df-81a3-63007afcb835'
AND user_id!='373d4006-2f91-470f-b256-195fsd5835e9'
AND user_id!='aaff2a33-2a75-4e65-a7re-658cb38e6549'
我也嘗試了這種變化但沒有成功：
DELETE FROM user WHERE EXISTS(
SELECT FROM user WHERE user_id!='2536466f-38d0-4e81-acda-2e411fdb3030'
AND user_id!='cefc6515-e4a4-460c-9fb2-eb883037ff9e'
AND user_id!='479acacf-3914-485f-958c-51sfe77e6beb'
AND user_id!='7436a5a6-1361-42df-81a3-63007afcb835'
AND user_id!='373d4006-2f91-470f-b256-195fsd5835e9'
AND user_id!='aaff2a33-2a75-4e65-a7re-658cb38e6549'
)
有沒有辦法做到這一點？
uj5u.com熱心網友回復：
您可以使用NOT IN.
ANDin yourWHERE子句不起作用，因為 uuid 可以在所有行中同時存在。
DELETE FROM user
WHERE user_id NOT IN (
'2536466f-38d0-4e81-acda-2e411fdb3030' ,
'cefc6515-e4a4-460c-9fb2-eb883037ff9e' ,
'479acacf-3914-485f-958c-51sfe77e6beb' ,
'7436a5a6-1361-42df-81a3-63007afcb835' ,
'373d4006-2f91-470f-b256-195fsd5835e9' ,
'aaff2a33-2a75-4e65-a7re-658cb38e6549'
) ;
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/451186.html
標籤：sql PostgreSQL sql-删除