Member Avatar for softDeveloper

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

  • 1 Contributor
  • 1 Reply
  • 167 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by softDeveloper
Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.