mysql 删除第一条记录

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

DELETE FROM users
ORDER BY id ASC
LIMIT 1;

DELETE FROM users
WHERE id = (SELECT id FROM users ORDER BY id ASC LIMIT 1);

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

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

-- 删除第一条记录
DELETE FROM users
ORDER BY id ASC
LIMIT 1;