MySQL 删除表行并重置索引

如何删除表的所有行并重置索引。

With TRUNCATE TABLE command

TRUNCATE TABLE `table-name`;

With DELETE FROM command

-- FIRST DELETE ALL ROWS
DELETE FROM `table-name`;
-- THEN RESET INDEX TO START FROM 1 AGAIN
ALTER TABLE `table-name` AUTO_INCREMENT = 1;

See here also for reference.

mysql database

🇨🇳 🇯🇵 📍 ⌚