mysql中如何批量删除数据

DELETE FROM users WHERE age > 30;

DELETE FROM users WHERE age > 30;
DELETE FROM users WHERE status = 'inactive';

DELETE FROM orders WHERE user_id NOT IN (SELECT id FROM users);

CREATE TEMPORARY TABLE temp_orders AS SELECT * FROM orders WHERE status = 'expired';
DELETE FROM orders WHERE id IN (SELECT id FROM temp_orders);
DROP TEMPORARY TABLE temp_orders;

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

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

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

-- 查看删除后的数据
SELECT * FROM users;