You are here: Re: 1 field or two? « PHP SQL « IT news, forums, messages
Re: 1 field or two?

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация