Re: Can i create a composite foreign key(on multiple columns) in a table.

2003-06-10 Thread Egor Egorov
san <[EMAIL PROTECTED]> wrote: > > Is it possible to create a composite foreign key (on multiple columns > as in primary key enabled tables) in a table. > > MySQl manuals defines the syntax as: > > The syntax of a foreign key constraint definition in InnoDB: > > [CONSTRAINT symbol] *FOREIGN K

Re: Can i create a composite foreign key(on multiple columns) in a table.

2003-06-07 Thread Becoming Digital
]> Sent: Friday, 06 June, 2003 09:05 Subject: Can i create a composite foreign key(on multiple columns) in a table. Hi, Is it possible to create a composite foreign key (on multiple columns as in primary key enabled tables) in a table. MySQl manuals defines the syntax as: The syntax

Can i create a composite foreign key(on multiple columns) in a table.

2003-06-06 Thread san
Hi, Is it possible to create a composite foreign key (on multiple columns as in primary key enabled tables) in a table. MySQl manuals defines the syntax as: The syntax of a foreign key constraint definition in InnoDB: [CONSTRAINT symbol] *FOREIGN KEY (index_col_name, ...)* RE