On Thu, 18 Dec 2003 09:05 am, Heikki Tuuri wrote:
> Mofeed,
>
> ----- Original Message -----
> From: "Mofeed Shahin" <[EMAIL PROTECTED]>
> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, December 18, 2003 12:20 AM
> Subject: Re: foreign keys.
>
> > Hmmm, Thanks for that.
> > But I'm not quite sure what it means.
> >
> > Mof.
> >
> > ------------------------
> > LATEST FOREIGN KEY ERROR
> > ------------------------
> > 031218 8:48:23 Error in foreign key constraint of table moftest/foo,
> > FOREIGN KEY (First_Name, Last_Name) REFERENCES Blah (First_Name,
>
> Last_Name))
>
> > TYPE=INNODB
> > Cannot resolve column name close to:
> > , Last_Name)) TYPE=INNODB
>
> does the table Blah have the columns First_Name and Last_Name?
Yep, here are both my create statements :
create table Blah (
ID INT PRIMARY KEY,
First_Name VARCHAR (50),
Last_Name VARCHAR(50),
UNIQUE (First_Name, Last_Name)
);
Query OK, 0 rows affected (0.00 sec)
create table foo (
ID INT PRIMARY KEY,
note VARCHAR(50),
First_Name VARCHAR(50),
Last_Name VARCHAR(50),
FOO_ID INT,
INDEX(FOO_ID),
INDEX(First_Name, Last_Name),
FOREIGN KEY (FOO_ID) REFERENCES foo(ID),
FOREIGN KEY (First_Name, Last_Name) REFERENCES Blah (First_Name, Last_Name)
) TYPE=INNODB;
ERROR 1005: Can't create table './moftest/foo.frm' (errno: 150)
Mof.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
