File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Android Security Essentials Live Lessons this week in the Android 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