Original Message -
> From: "Chris Tucker" <[EMAIL PROTECTED]>
> To: "kayamboo" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 17, 2002 5:35 PM
> Subject: Re: table creation error with innodb/ sql,query
>
>
> > InnoDB requires that you ha
ROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Sent: Tuesday, September 17, 2002 5:35 PM
Subject: Re: table creation error with innodb/ sql,query
> InnoDB requires that you have an index on both ends of a foreign key
> constraint. Thus, you need to index the "type
Hello experts
I am trying to create innodb tables with foreign key relations but I get
error 150 meaning that foregin key constraint can't be established.
Here are the statements
1.CREATE TABLE relation( type VARCHAR(50) NOT NULL PRIMARY KEY)TYPE =
INNODB;
2.CREATE TABLE person( name VARCHAR(50
