Cannot truncate a table referenc

2020-01-20 本文已影响0人梨花菜

Navicat截断表提示外键冲突

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE reportdetail;
TRUNCATE TABLE report;
SET FOREIGN_KEY_CHECKS = 1;