This week's giveaways are in the MongoDB and Jobs Discussion forums.
We're giving away four copies of Mongo DB Applied Patterns and 4 resume reviews from Five Year Itch and have the authors/reps on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes newbie question on database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Mongo DB Applied Patterns this week in the MongoDB forum
or a resume review from Five Year Itch in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "newbie question on database" Watch "newbie question on database" New topic
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
    
  10
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
 
I agree. Here's the link: http://zeroturnaround.com/jrebel
 
subject: newbie question on database
 
Similar Threads
nx:All of URLy Bird 1.1.3 how to deal with data from database file
How to embed activex in HTML page
Naming Objects
a complex one-to-one problem
Newbie validation with textfile