Kuhn
> Cc: mysql@lists.mysql.com
> Subject: Re: Primary and Foreign Keys (Follow Up)
>
> Hello. I appreciate your input. To clarify, I will provide you with an
> example:
>
> I have a table called business and another one called
> food_business. The
> field business_id is a pr
Hello. I appreciate your input. To clarify, I will provide you with an
example:
I have a table called business and another one called food_business. The
field business_id is a primary key of table business and a foreign key of
table food_business. In this case, the foreign key is unique and althou
If your FK really is unique, you don't need two tables. Example
First table Second Table
ID FK
1 1
2 2
3 3
...
So you can make this one table. On other words, it would be a one-to-one
relation. And this would be one table. Only with a one-
