Answers for "Cannot truncate a table referenced in a foreign key constraint (`wp2cart_wp2cart_com_dxbsafe`.`amazon_quote`, CONSTRAINT `AMAZON_QUOTE_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES"

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 "Cannot truncate a table referenced in a foreign key constraint (`wp2cart_wp2cart_com_dxbsafe`.`amazon_quote`, CONSTRAINT `AMAZON_QUOTE_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES"