mysql 删除两条相同的记录

DELETE FROM users WHERE id = 1 LIMIT 2;

-- 创建示例表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

-- 插入示例数据
INSERT INTO users (id, name, email) VALUES (1, 'Alice', 'alice@example.com');
INSERT INTO users (id, name, email) VALUES (1, 'Alice', 'alice@example.com');

-- 删除两条相同的记录
DELETE FROM users WHERE id = 1 LIMIT 2;

DELETE FROM users WHERE id = 1 LIMIT 2;

DELETE FROM users
WHERE id IN (
    SELECT id
    FROM (
        SELECT id, COUNT(*) as cnt
        FROM users
        GROUP BY id
        HAVING cnt > 1
    ) as subquery
)
LIMIT 2;