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]
