Mofeed Shahin <[EMAIL PROTECTED]> wrote: > > 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) >
What is version of MySQL server? What default-character-set do you use? > > 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) >> -- 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]
