AUTO_INCREMENT issue

[Anon]

Here is a snippet of my table creation code:

CREATE TABLE members (
member_id INT(7) ZEROFILL PRIMARY KEY AUTO_INCREMENT NOT NULL UNSIGNED,
...
XXXXXXXX
};

My problem is that I don't want the first entry to be given the value of "0000001", but start at "0000100", or "100" instead of "1". I read awhile back something about putting the code "AUTO_INCREMENT = 100" in place of the "XXXXXXX" above, but that doesn't work for me.

Anyone know?

[Anon]

You can't do that in the table definition. However, you can manually assign the value for member_id with the first insert. You can insert a 'dummy' record with the value set to 99. Then after you've started entering 'real' records you can remove the dummy.