in reply to Re: Re: perl (mysql) question...
in thread perl (mysql) question...

There are good reasons to have as your primary key an autoincrement value rather than the "nick".

Think of what would happen when a user changes his "nick". All foreign links to this nick would need to be changed as well if "nick" was the primary key.

Far better to define "nick" as UNIQUE (to disallow duplicates) and INDEX it (to speed up searches and access).

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law