Re: auto-increment by a specific number

2005-04-18 Thread gerald_clark
StinkyPup wrote:
How do I auto-increment by a specific number. For example by 100:
 

You dont.
IDData
100  blah blah blah
200  blah blah foo
ALTER TABLE PRODUCT AUTO_INCREMENT = 100
doesn't do what I want to do.
TIA
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


auto-increment by a specific number

2005-04-15 Thread StinkyPup
How do I auto-increment by a specific number. For example by 100:

IDData
100  blah blah blah
200  blah blah foo


ALTER TABLE PRODUCT AUTO_INCREMENT = 100
doesn't do what I want to do.

TIA

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]