Welcome to WebmasterWorld Guest from 54.163.100.58

Forum Moderators: coopster & jatar k

Disabling Foreign Key Constraints

How to enable/disable foreign keys

   
9:53 pm on Sep 4, 2010 (gmt 0)



I have a table in phpMyAdmin that has a primary key. I'd like to drop the table to prepare for a new import; but I can't do that without disabling the table's associated foreign keys; otherwise I get constraint errors. I can disable a foreign key by simply temporarily deleting the key in the associated table. However, is there a simpler way of enabling/disabling foreign keys in phpMyAdmin. If not, what is the simplest way of automating this mundane task?
10:34 pm on Sep 4, 2010 (gmt 0)

5+ Year Member



Hi,

You should be able to use the query:
SET FOREIGN_KEY_CHECKS=0;

To disable foreign key checks, set it to one to re-enable after you've finished.

Andrew
6:20 pm on Sep 5, 2010 (gmt 0)



Excellent!...............thank you.
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month