Try this: When you add an AUTO_INCREMENT column, column values are filled in with sequence numbers for you automatically. For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. See section 14.5.3.1 SET Syntax.
>From here: http://www.mysql.com/doc/en/ALTER_TABLE.html On Thu, 01 Apr 2004, Amit Wadhwa wrote: > > Hi All, > I was wondering if there was a way in mySQL wherein I tell the > autoincrement spec where to start from? > Eg. Autoincrement startfrom 10000 > And the values go in as: > 10001..10002 and so on,.. instead of 1..2..3.. > ..like sequencing in oracle... > Ò0 > Any help is appreciated, > Thanks > Amit Wadhwa > Data Analyst > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]