Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

newbie question on database

 
carl chan
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,
This is the first time that my boss ask me to create a table to store some customer's records.
Each customer should have a unique ID as the primary key. My question is that how should i create a table which generate a new customer ID each time when a new record is add??
Thanks
 
Marilyn de Queiroz
Sheriff
Posts: 9059
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using Oracle, mySQL or which? Autoincrement is different with each one.
 
carl chan
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using MySQL.
Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic