|
Posted by Ryan Heuser on 06/07/05 17:09
NC wrote:
> ... So how do
> you figure which Congo you are talking about unless you have
> a numeric code for it? How would you handle the name changes
> from Belgian Congo to Zaire to D.R. of Congo, if the name
> were a key?
I agree with NC. You will probably be making refences to these rows in this
table. Let's say you have a table called languages, and these language
rows point to countries that they are used in. These pointers will break
if you are using the name of the country as its key, and you change the
name without changing every single reference to it.
Personally, I always use an auto_increment key for every table I use. It
just makes me feel better. :)
Peace,
Ryan 'RetroMan' Heuser
Navigation:
[Reply to this message]
|