mysql删除多个对象 in

DELETE FROM table_name WHERE column_name IN (value1, value2, ..., valueN);

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

SELECT * FROM users WHERE id IN (1, 3, 5);
SHOW GRANTS FOR 'your_username'@'localhost';

CREATE INDEX idx_user_id ON users(id);
DELETE FROM users WHERE id IN (1, 3, 5) LIMIT 1000;

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

INSERT INTO users (id, name, email) VALUES
(1, 'Alice', 'alice@example.com'),
(2, 'Bob', 'bob@example.com'),
(3, 'Charlie', 'charlie@example.com'),
(4, 'David', 'david@example.com'),
(5, 'Eve', 'eve@example.com');

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