Posted by David on 07/30/06 11:52

On Sat, 29 Jul 2006 14:53:34 GMT, "Dimitri Marshall"
<recipient@shawRemoveThis.ca> wrote:

>Hey Guys,
>
>Ya in my userAccounts table I use the e-mail address and username, although
>in this case I did need a number of some sort. I did figure out
>auto_increment and obviously it wasn't as hard as I was letting on. Anyway,
>it was fun trying to make my own!

You can use both the email address and the username as primary keys.
By declaring both to be primary keys, they will be treated as "one"
big key. Personally, I have not found too much use for autoincrement.

If I really want unique fields, I find it better to generate the
data myself based on some combination of fields of data. At least
when I look at my unique field, it is something familiar to me, rather
than simply having some numbers go from 1 to whatever.


>Thanks,

Anytime

David

[Back to original message]