MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Alter table add foreign key causes can't create table error
Posted by: pia D'Alia
Date: December 20, 2013 10:33AM

Check that BOTH tables have the same ENGINE. For example if you have:

CREATE Table FOO ();
and:

CREATE Table BAR () ENGINE=INNODB;
If you try to create a constraint from table BAR to table FOO, it will not work on certain MySQL versions.

Fix the issue by following:

CREATE Table FOO () ENGINE=INNODB;

http://update9.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Alter table add foreign key causes can't create table error
Andrew Cutforth
December 20, 2013 07:42AM
Re: Alter table add foreign key causes can't create table error
Peter Brawley
December 20, 2013 09:52AM
Re: Alter table add foreign key causes can't create table error
pia D'Alia
December 20, 2013 10:33AM
Re: Alter table add foreign key causes can't create table error
Rick James
December 20, 2013 11:49AM
Re: Alter table add foreign key causes can't create table error
Andrew Cutforth
December 23, 2013 06:34AM


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.