mysql怎么删除多条数据

DELETE FROM users WHERE age > 30;

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

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

SET @batch_size = 1000;
SET @rows_deleted = 0;
REPEAT
    DELETE FROM users WHERE age > 30 LIMIT @batch_size;
    SET @rows_deleted = @rows_deleted + ROW_COUNT();
UNTIL @rows_deleted = 0 END REPEAT;

DELETE FROM users WHERE age > (SELECT MAX(age) FROM max_age);

-- 创建示例表
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;