这意味着您需要首先将foreign_key_check设置为禁用,然后需要截断表。语法如下 -
set FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE yourTableName1; TRUNCATE TABLE yourTableName2; TRUNCATE TABLE yourTableName3; . . . . TRUNCATE TABLE yourTableNameN; set FOREIGN_KEY_CHECKS = 1;
这意味着您需要首先将foreign_key_check设置为禁用,然后需要截断表。语法如下 -
set FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE yourTableName1; TRUNCATE TABLE yourTableName2; TRUNCATE TABLE yourTableName3; . . . . TRUNCATE TABLE yourTableNameN; set FOREIGN_KEY_CHECKS = 1;
之前