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 ?
How to INSERT with an autoincrement column
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?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014