Computer and IT knowledge - things to know

mysql error: Cannot truncate a table referenced in a foreign key constraint

#just turn off foreign key checks

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE yourtable1;
TRUNCATE yourtable2;

SET FOREIGN_KEY_CHECKS = 1;

computer2know :: thank you for your visit :: have a nice day :: © 2024