MySQL :: Re: Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Posted by: Peter Brawley
Date: February 06, 2022 10:42AM

To help with that, we'll need to see the results of Show Create Table for each of these three tables.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Rajdeep Bhattacharya

February 06, 2022 01:03AM

Re: Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Peter Brawley

February 06, 2022 10:42AM

Re: Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Rajdeep Bhattacharya

February 06, 2022 01:02PM

Re: Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Peter Brawley

February 06, 2022 03:08PM

Re: Same Foreign Key from two table referring to a single Primary Key to a third table - MySql is not recognising the second Foreign Key in MySql Workbench.

Phillip Ward

February 07, 2022 09:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.