File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes can we preset value of auto-increment ? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "can we preset value of auto-increment ?" Watch "can we preset value of auto-increment ?" New topic
Author

can we preset value of auto-increment ?

Nakata kokuyo
Ranch Hand

Joined: Apr 13, 2005
Posts: 437
hi, can we preset the auto increment value to certain start number ?

ie: i let the auto-increment column start with number like 10001 , any insertion of the table will then keep increase number to 10002, 10003 and so on ?

i'm using mysql 5.0

thank you
Scott Johnson
Ranch Hand

Joined: Aug 24, 2005
Posts: 518
Yes, you can set this value. The Mysql manual explains how.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: can we preset value of auto-increment ?
 
Similar Threads
How to INSERT with an autoincrement column
autoincrement invoice
Selecting some entries in selectManyListbox
can we get the preset auto-increment number before any insertion
duplicate created in AUTO INCREMENT in mysql if its possible?