MySQL Forums
Forum List  »  InnoDB

Re: set foreign_key_checks = 0; only kinda works
Posted by: Ryan Lowe
Date: December 25, 2008 07:53PM

Even if foreign_key_checks = 0, InnoDB does not allow the creation of a foreign key constraint where a column references a non-matching column type. So you basically have to drop the constraint before changing the data type.

-- Ryan Lowe

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: set foreign_key_checks = 0; only kinda works
5486
December 25, 2008 07:53PM


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.