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
The InnoDB manual (below) doesn't mention it. Why not try and let us know? http://www.innodb.com/ibman.html#InnoDB_foreign_keys Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "san" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, 06 June, 200