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, 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 of a foreign key constraint definition in InnoDB:
[CONSTRAINT symbol] *FOREIGN KEY (index_col_name, ...)*
REFERENCES table_name (index_col_name, ...)
[ON DELETE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
[ON UPDATE {CASCADE | SET NULL | NO ACTION
| RESTRICT}]
Kindly give solutions to my query.
Thanks for your time
Regards
San
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
