Posts: 6,236
Threads: 310
Joined: Jan 2011
Reputation:
0
Are you referring to an auto incrementing primary key?
Posts: 2,187
Threads: 81
Joined: Aug 2011
Reputation:
0
He means something like the AUTO_INCREMENT primary key which is a unique number assigned to every NEW entry of a row in the table.
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
1. Ids are used because numerical searches are faster than string searches, and because they are always unique. They also provide a good reference to and from the table when working with relations.
2. Yes. auto_increment fields are a MySQL server feature, not a client feature.
3. No. See above.
Posts: 912
Threads: 116
Joined: Jun 2012
Reputation:
0
If you want ID's for each players thats registers on your server just add ID with AI on it, I don't see the point in havings ID's you're better off with registration dates