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
Subject
Views
Written By
Posted
19283
December 17, 2008 02:03PM
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.