hehehe, Yeah figures that it was something stupid I did!!! Thanks for that.
Mof. On Thu, 18 Dec 2003 09:30 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:47 AM > Subject: Re: foreign keys. > > > 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) > > but the table above is MyISAM type? > > FOREIGN KEY relationships can only be defined between InnoDB type tables! > > > 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. > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM > tables > > Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]