mysql如何删除多条记录

DELETE FROM users WHERE age > 30;

DELETE FROM users WHERE id IN (1, 3, 5);

DELETE users FROM users LEFT JOIN orders ON users.id = orders.user_id WHERE orders.user_id IS NULL;

DELETE FROM users WHERE id IN (SELECT id FROM users WHERE name LIKE 'A%');

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

-- 插入示例数据
INSERT INTO users (name, age) VALUES ('Alice', 25), ('Bob', 35), ('Charlie', 40);

-- 删除年龄大于30岁的用户
DELETE FROM users WHERE age > 30;

-- 查看结果
SELECT * FROM users;