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]
