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 code example
Example: how to force truncate a table in mysql
DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;