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.
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
this should sort you out..
Regards
Joe
-Original Message-
From: Amit Wadhwa [mailto:[EMAIL PROTECTED]
Sent: 01 April 2004 23:33
To: [EMAIL PROTECTED]
Subject: question on autoincrement
Hi All,
I was wondering if there was a way in
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 1
And the values go in as:
10001..10002 and so on,.. instead of 1..2..3..
..like sequencing in oracle
Any help is appreciated,
Thanks
Amit Wadhwa
Data A
