Answers for "how to force truncate a table with foreign keys in mysql"

mysql how to truncate table with foreign keys

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;

SET FOREIGN_KEY_CHECKS = 1;

Posted by: Guest on March-06-2021

how to force truncate a table in mysql

DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;

Posted by: Guest on December-21-2020

Code answers related to "how to force truncate a table with foreign keys in mysql"