MySQL Forums
Forum List  »  Newbie

Re: drop all constraints, then reinstate all constraints??? is there a way to do this??
Posted by: derek martin
Date: February 24, 2009 08:10AM

Simply run this before your query:

SET FOREIGN_KEY_CHECKS = 0;

And this after:

SET FOREIGN_KEY_CHECKS = 1;

:)

Options: ReplyQuote


Subject
Written By
Posted
Re: drop all constraints, then reinstate all constraints??? is there a way to do this??
February 24, 2009 08:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.