You shouldn't have a problem if you list each foreign
key separately, as follows:
foreign key (MenuName) references MenuDetails
(MenuName)on update restrict on delete restrict,
foreign key (MenuParentName) references MenuDetails
(MenuParentName)on update restrict on delete restrict,
That's how
B.K.R.,
Saturday, July 13, 2002, 7:08:54 AM, you wrote:
BKRS> The below mentioned sql makes an error when created
BKRS> with two foreign key constraints under MySQL/Innodb
BKRS> table type. Any help to solve this problem?
BKRS> create table UserMenuRestrictions
BKRS> (
BKRS> CompanyCode
: ""B.K.R. Shivaprakkash"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, July 13, 2002 7:13 AM
Subject: Re: More than one foreign key in a table
> Hi,
>
> The below mentioned sql makes an error when created
> with two foreign key const
Hi,
The below mentioned sql makes an error when created
with two foreign key constraints under MySQL/Innodb
table type. Any help to solve this problem?
create table UserMenuRestrictions
(
CompanyCodechar(10) not null,
UserId char(10) not nul
B.K.R.,
Tuesday, June 18, 2002, 5:52:07 AM, you wrote:
BKRS> Can I have more than one foreign key defined in a
BKRS> single table using MySQL/Innodb table type?
Yes, it's possible.
BKRS> It gives an error in .frm file, if tried to have
BKRS> that?
BKRS> Any solution?
Check your CREATE TABLE de