Skip navigation links

MySQL Forums :: Foreign Keys (Referential Integrity) :: Problem defining a composite FK


Advanced Search

Re: Problem defining a composite FK
Posted by: Francisco Jordán ()
Date: August 06, 2010 05:46AM

First of all, thank you for your answer :)

Im going to try what you wrote but i dont really understand it. You are just adding a new "key" -> KEY `Lat` (`Lat`,`Long`)

And then, giving a name to the FK -> CONSTRAINT `child_t_ibfk_1`

But you are not using the Key you created so, can you explain to me please? I would like to learn :D


About your question, i can check the table structure because im using Xampp, its an Apache web server distribution wich includes mysql, php and perl. It gives you a graphic view over all mysql tables you create.


Thank you!

Options: Reply•Quote


Subject Views Written By Posted
Problem defining a composite FK 3132 Francisco Jordán 08/05/2010 06:07AM
Re: Problem defining a composite FK 1141 Devart Team 08/06/2010 12:50AM
Re: Problem defining a composite FK 1054 Francisco Jordán 08/06/2010 05:46AM
Re: Problem defining a composite FK 1092 Devart Team 08/06/2010 06:27AM
Re: Problem defining a composite FK 1029 Francisco Jordán 08/07/2010 02:55AM
Re: Problem defining a composite FK 1028 Devart Team 08/09/2010 12:03AM
Re: Problem defining a composite FK 930 Francisco Jordán 08/17/2010 09:22AM
Re: Problem defining a composite FK 920 Devart Team 08/18/2010 01:31AM
Re: Problem defining a composite FK 1021 Francisco Jordán 08/19/2010 06:03AM
Re: Problem defining a composite FK 1344 Devart Team 08/19/2010 11:18PM


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

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.