Primary key should always be auto increment - Database

Discussion

• Nirja Shah   -Posted on 02 Nov 15
  - Auto-incrementing primary keys are useful for several reasons:
  
  1. They do not allow duplicate user names.
  
  2. They allow the user name (or email address, if that's used to login) to be changed (easily)
  
  3. Selects, joins and inserts are faster than varchar primary keys as its much faster to maintain a numeric index
  
  4. Validation becomes very simple.
  
  5. Sanitation of input is trivial
  
  6. There is far less overhead as foreign keys don't have to duplicate potentially large string values
  
  

➨ Post your comment / Share knowledge