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 KEY

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

2003-06-07 Thread Becoming Digital
: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 of a foreign key constraint definition

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

composite foreign key..?

2001-03-13 Thread vijay khanna
Friends. people out in here are very afraid , when they hear Mysql does not support foreign keys. It really become difficult , why foreign keys are not enforced by mysql. I wish , there was another way. Anyways, can u please tell me does our favourite database support composite foreign key

Re: composite foreign key..?

2001-03-13 Thread Rolf Hopkins
is the fastest in the world. - Original Message - From: "vijay khanna" [EMAIL PROTECTED] To: "mysql (E-mail)" [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:40 Subject: composite foreign key..? Friends. people out in here are very afraid , when they hear Mysql does not