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]
