unable to add or update rows;

[Chariti]

hello there, i created 3 tables as given below:

create table x
(
id int primary key not null
)type=innodb

create table y
(
id1 int primary key not null
)type=innodb

create table z
(
fo_k int not null,

foreign key(fo_k) references x(id),
foreign key(fo_k) references y(id1)
)type=innodb

the table was created sucessfully but cant able to add values to the table z, is there any possiblities of having a single foreign key in a table that references more than one primary key of other table?

z(fo_k)<->x(id) or z(fo_k) <-->y(id1)

help me! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Reed]

check if the key exists in the other table(s). if not, do it!
also, Table Z column fo_k needs to have an index. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --