Answers for "18:52:10 TRUNCATE TABLE customers Error Code: 1701. Cannot truncate a table referenced in a foreign key constraint (`coffee_store`.`orders`, CONSTRAINT `orders_ibfk_2`) 0.0037 sec"

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 "18:52:10 TRUNCATE TABLE customers Error Code: 1701. Cannot truncate a table referenced in a foreign key constraint (`coffee_store`.`orders`, CONSTRAINT `orders_ibfk_2`) 0.0037 sec"