| Author |
newbie question on database
|
carl chan
Ranch Hand
Joined: Mar 12, 2003
Posts: 42
|
|
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
Joined: Jul 22, 2000
Posts: 9033
|
|
|
Are you using Oracle, mySQL or which? Autoincrement is different with each one.
|
JavaBeginnersFaq
"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
|
 |
carl chan
Ranch Hand
Joined: Mar 12, 2003
Posts: 42
|
|
I am using MySQL. Thanks
|
 |
 |
|
|
subject: newbie question on database
|
|
|