WITH ab AS (
SELECT id – pk column or any (set of) unique column(s)
FROM db1
WHERE sitename= ‘测试’
LIMIT 10000 – arbitrary pick (cheapest)
)
UPDATE db1
SET iss_time= ‘2025’
FROM db1
WHERE id in(select id from ab)
RETURNING id
postgres 限制数量更新数据的优化方法
最新推荐文章于 2023-11-08 12:54:59 发布