This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
Similar Threads
Naming Objects
How to embed activex in HTML page
a complex one-to-one problem
nx:All of URLy Bird 1.1.3 how to deal with data from database file
Newbie validation with textfile