| 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.
|
|
 |
|
|
subject: can we preset value of auto-increment ?
|
|
|
0
