Quick SQL question

Kevo

Hi,
I am getting an error when creating a table of mine due to a foreign key in a MYSQL database.

e.g.
Tables:
A
idA PK

B
idB
FK references A (idB->idA)

C
idC
FK reference A (idC->idA)

Is there some problem with this? I seem to be able to make one table referencing A with a foreign key but I cannot make two(Error 121).

Thanks.

Beano

what error are you getting?

Seth Brundle

Double check dataypes on common fields.
Is the table containing the PK created before the FK table?
stick up your code!

Kevo

Ok so I explained that rather poorly. I oversimplified the problem. I just wanted to know was I making a very obvious error. If not it must be syntax.


I will post code in a few mins.


EDIT:
Fixed my problem. All my FKs had the same name. I thought this would be ok since they are in different tables but I guess that since they reference the same table it becomes a problem.

Seth Brundle

Cool.
FYI any structural item within a DB schema can be regarded as an object and gets a unique name.