How to truncate a MySQL table in spite of a foreign key
This can be done by disabling index checks. Yes you can: SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table1; TRUNCATE table2; SET FOREIGN_KEY_CHECKS = 1; With these
Copyright 2025 © All rights Reserved