Mysql - disabling and enabling foreign key checks

Mysql - disabling and enabling foreign key checks
//

Recently I was working on a project in which I have to truncate tables in database. But due to foreign key constraints MySQL was throwing errors.
So the solution I found was to disable Foreign Key constraints temporarily delete all data and then again enable the foreign keys.

Disable
Read More about it from the following link : http://coding-guru.com/mysql-disabling-and-enabling-foreign-key-constraint/ posted by Techy

• Tweet
• Share
• Share
• Share
• Share