常用的优化mysql数据库

DELETE FROM tablename WHERE id

4. 使用事务

BEGIN; SELECT * FROM tablename WHERE id >10; COMMIT;