aspose file tools*
The moose likes JDBC and the fly likes newbie question on database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "newbie question on database" Watch "newbie question on database" New topic

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??
Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9044
Are you using Oracle, mySQL or which? Autoincrement is different with each one.

"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.
I agree. Here's the link:
subject: newbie question on database