MySQL – How to temporarily disable a foreign key constraint
To disable foreign key constraints when you want to truncate a table: Use FOREIGN_KEY_CHECKS and remember to enable it when you’re done:
- Posted on:
-
Author:
admin
- Categories: Database, Mysql
- Tags: disable foreign key, enable foreign key, foreignkey, foreignkeycheck, mysql, mysql disable foreign key, mysql enable foreign key
- Leave a comment: MySQL – How to temporarily disable a foreign key constraint