Mofeed, if you are using a relatively recent version of 4.0, or 4.1.1, please look with
SHOW INNODB STATUS\G what is the latest FOREIGN KEY error. 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/ ----- Original Message ----- From: "Mofeed Shahin" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 17, 2003 1:19 AM Subject: Re: foreign keys. > > mysql> 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. > > On Tue, 16 Dec 2003 07:54 pm, Victoria Reznichenko wrote: > > Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > > Still doesn't work.... But thanks for trying. > > > > Worked fine for me: > > > > mysql> CREATE TABLE Blah ( > > -> ID INT PRIMARY KEY, > > -> Fname VARCHAR (50), > > -> Lname VARCHAR (50), > > -> UNIQUE (Fname, Lname) > > -> ) TYPE=INNODB; > > Query OK, 0 rows affected (0.11 sec) > > > > mysql> CREATE TABLE foo ( > > -> ID INT PRIMARY KEY, > > -> note VARCHAR(50), > > -> Fname VARCHAR(50), > > -> Lname VARCHAR(50), > > -> FOO_ID INT, > > -> INDEX(FOO_ID), > > -> INDEX(Fname, Lname), > > -> FOREIGN KEY (FOO_ID) REFERENCES foo(ID), > > -> FOREIGN KEY (Fname, Lname) REFERENCES Blah (Fname, Lname) > > -> ) TYPE=INNODB; > > Query OK, 0 rows affected (0.10 sec) > > > > > Mof. > > > > > > On Tue, 16 Dec 2003 11:40 am, Aftab Jahan Subedar wrote: > > >> If you have foreign key then add a key for each, > > >> so the > > >> > > >> > CREATE TABLE foo ( > > >> > ID INT PRIMARY KEY, > > >> > note VARCHAR(50), > > >> > Fname VARCHAR(50), > > >> > Lname VARCHAR(50), > > >> > FOO_ID INT, > > >> > INDEX(FOO_ID), > > >> > > >> KEY(Fname,Lname), #here this one--if it does not work,its not me > > >> > > >> > FOREIGN KEY (FOO_ID) REFERENCES foo(ID), > > >> > FOREIGN KEY (Fname, Lname) REFERENCES Blah (Fname, Lname) > > >> > ) TYPE=INNODB; > > > > -- > > For technical support contracts, goto https://order.mysql.com/?ref=ensita > > This email is sponsored by Ensita.net http://www.ensita.net/ > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > > <___/ www.mysql.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
