MySQL: Should my user ID be the initial key of an INT auto-increment, starting at 1?

Question

I am starting a programmer by creating a non-profit website.

I need a user ID, and I thought it would be logical to use a simple INTEGER field with auto-increment for this. Does this make sense? The user ID will not be used directly by users (they will need to select a username); should I take care of where they start (supposedly 1)?

Any other recommendations I should use when creating the Users table?

Thank!

Jdelage

Answer 1

. , . , 1, , , "" . ( , , , , , ).

, (, ). ( UNIQUE), .

:

• , .

• PK, , , , , , .

• , .

Answer 2

auto_increment . .
, . .

, . ? Auto_inqrement . , 98361, . , , , ( ..).

Answer 3

, . 1, . 0 .

, , md5 ( ) - .

Answer 4

, , Problably , , - , (md5) .

Answer 5

, , , , .., .

Answer 6

, , , , , id . . , id .

, , , id. , , , . , .