PHP SQL - Foreign keys and references?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Foreign keys and references?

Tony Peardon

2006-02-08, 6:58 pm

Could some please quickly explain the difference between a foreign key and a
reference? Thanks.

J.O. Aho

2006-02-08, 6:58 pm

Tony Peardon wrote:
> Could some please quickly explain the difference between a foreign key and a
> reference? Thanks.

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
http://dev.mysql.com/doc/refman/5.0...onstraints.html

//Aho

Jim Michaels

2006-02-22, 6:57 pm

"J.O. Aho" <user@example.net> wrote in message
news:44ukfaF42ddbU1@individual.net...
> Tony Peardon wrote:
>
> http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
> http://dev.mysql.com/doc/refman/5.0...onstraints.html
>
>
> //Aho

I think what he's saying is that a foreign key refers to ("REFERENCES") a
primary key. the relationship is the reference if I'm not mistaken.

Sponsored Links