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

🇨🇳 🇯🇵 📍 ⌚