File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
can we preset value of auto-increment ?
Joined: Apr 13, 2005
Nov 17, 2006 17:59:00
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
Joined: Aug 24, 2005
Nov 17, 2006 20:20:00
Yes, you can set this value. The
It is sorta covered in the
JavaRanch Style Guide
subject: can we preset value of auto-increment ?
can we get the preset auto-increment number before any insertion
How to INSERT with an autoincrement column
duplicate created in AUTO INCREMENT in mysql if its possible?
Selecting some entries in selectManyListbox
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013