-- 删除指定用户 DELETE FROM users WHERE id = 10; -- 删除非活跃用户 DELETE FROM users WHERE status = 'inactive' AND last_login < '2023-01-01'; -- 删除重复记录（保留ID最小的） DELETE FROM users WHERE id NOT IN ( SELECT MIN