MySQL Delete all rows from table and reset ID to zero

• By admin
• Posted in General IT
• On 12월 22, 2016
• No Comments.

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 ;