UPDATE sg_member
SET sys_org_code = 'A01A02'
WHERE id IN (
SELECT id FROM (
SELECT id FROM sg_member ORDER BY id LIMIT 20
) AS excluded_ids
);
mysql指定更新前20条数据
最新推荐文章于 2024-06-18 21:52:50 发布
UPDATE sg_member
SET sys_org_code = 'A01A02'
WHERE id IN (
SELECT id FROM (
SELECT id FROM sg_member ORDER BY id LIMIT 20
) AS excluded_ids
);