Hi all,

I have a table 'table 1' which has a primary key. Now I want to create two other tables with a composite key in each one, composed by primary key and a foreign key both referencing table 1 's primary key. However I can only do it with one of the tables at each time. CanĀ“t a a primary key reference two tables at the same time? All the types and collations are according to table 1.

Thanks in advance

5 Years
Discussion Span
Last Post by softDeveloper

Solved: it was related to the foreign key name given in the mysql workbench, I tried it in the command line and it worked changing the foreign key name, then I did the same in workbench and it's working

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.