mysql如何批量删除数据

DELETE FROM table_name WHERE condition;

DELETE FROM users WHERE age > 30;

DELETE FROM table_name WHERE id IN (SELECT id FROM another_table WHERE condition);

DELETE FROM orders WHERE order_id IN (SELECT order_id FROM order_status WHERE status = 'cancelled');

CREATE TEMPORARY TABLE temp_table AS SELECT * FROM table_name WHERE condition;
DELETE FROM table_name WHERE id IN (SELECT id FROM temp_table);
DROP TEMPORARY TABLE temp_table;

CREATE TEMPORARY TABLE temp_products AS SELECT * FROM products WHERE price < 10;
DELETE FROM products WHERE product_id IN (SELECT product_id FROM temp_products);
DROP TEMPORARY TABLE temp_products;

DELETE FROM table_name WHERE condition LIMIT 1000;

ALTER TABLE table_name ADD INDEX index_name (column_name(255));

DELETE t1 FROM table_name t1 JOIN table_name t2 WHERE t1.id = t2.id AND t1.column = 'value';