SET FOREIGN_KEY_CHECKS = 0; — disable a foreign keys check
SET AUTOCOMMIT = 0; — disable autocommit
START TRANSACTION; — begin transaction
DELETE FROM table_name;
ALTER TABLE table_name AUTO_INCREMENT = 1;
— or
TRUNCATE table_name;
— or
DROP TABLE table_name;
CREATE TABLE table_name ( … );
SET FOREIGN_KEY_CHECKS = 1; — enable a foreign keys check
COMMIT; — make a commit
SET AUTOCOMMIT = 1 ;