asked on
General database theory
Many times an auto-generated number is used as the primary key. According to what I have learned, the best would be to have a primary key straight from the "true data" if it is possible. Comments on that?
Databases
Last Comment
Dave Baldwin
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
So an auto_incremented ID key has no good things about it?
auto incremented key can be a primary key as it is always going be +1 of the previous.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
In MySQL, auto-increment primary key serves the purpose of a unique row id very well. It should not be used for any other purpose though.