Page 1 of 1
Auto increment from a specific value [SOLVED]
Posted: Wed Nov 17, 2004 7:46 am
by hairyjim
Hi all,
Is it possible to auto increment a field, but instead of starting from 1 I want it to start from 44403707. Is this possible?
Posted: Wed Nov 17, 2004 8:51 am
by CoderGoblin
Using which Database system....
Posted: Wed Nov 17, 2004 8:52 am
by phpScott
yes just insert a value into your auto increment column along with the rest of the record
ie 12849, bob, smith
next record will auto_increment to 12850
Posted: Wed Nov 17, 2004 9:12 am
by hairyjim
Whoops yeah sorry. MySQL.
Cheers Scott - I should have thought of that!
Posted: Wed Nov 17, 2004 9:19 am
by Wayne
You can specify the start value of the auto_increment column when you create the table, check your MySQL manual regarding table creation and auto_increment columns.