Disabling Foreign Key Constraints

How to enable/disable foreign keys

[calmseas]

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?

[Little_G]

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

[calmseas]

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