MySql Auto Increment Feature

[thorn_jebachina]

Is there any way to set deafult value in auto-increment column type.

For Example:

I want auto_increment to start from 10000 instead of 1

[leatherback]

RTFM @ mysql.org

ALTER TABLE tbl_name AUTO_INCREMENT = 1000
will start your records at 1000

J.

[onlinegs]

Also, you could insert an initial row, and manually set the colume at 1000, and it will begin counting up from there.