---

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table $table_name;
SET FOREIGN_KEY_CHECKS = 1;

來源：
https://stackoverflow.com/questions/5452760/how-to-truncate-a-foreign-key-constrained-table

--
※ 作者: mesak 時間: 2021-08-27 13:43:26 (台灣)