File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes newbie question on database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 9059
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
It's not a secret anymore!