[RESOLVED] MySQL table structure for autoincrement feild starting at 1000

jme

Hi, I am desiging a MySQL table where there needs to be a value which is incremented with each addition. I can create a field like this. However I now need to start the values from 1000 rather than 0

ie, the first option will be 1000, then 1001, 1002 etc ...

How could i go about this?

Many thanks 🙂

laserlight

You could use something like:
ALTER tablename AUTO_INCREMENT=1000;

jme

laserlight wrote:
You could use something like:
ALTER tablename AUTO_INCREMENT=1000;

Thanks for your reply but the above gives a 1064 error:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'fps_items AUTO_INCREMENT = 1000' at line 1

toplay

See syntax here:
http://dev.mysql.com/doc/mysql/en/alter-table.html

It's basically:

ALTER TABLE tablename AUTO_INCREMENT=1000;

Note that's for modifying an existing table. If you're creating a new table, then you can specify the AUTO_INCREMENT=1000 option as part of the create SQL (so it will start with that number).

http://dev.mysql.com/doc/mysql/en/create-table.html

jme

all sorted now - thanks both for your help! 🙂