MySQL 删除表数据，重置自增 id 为 0

• truncate table user;

遇到问题：Cannot truncate a table referenced in a foreign key constraint …

解决：
SET foreign_key_checks = 0; 关闭外键约束
SET foreign_key_checks = 1; 开启外键约束