[PHP] MYSQL start an auto_increment at a certain number

[Jared Howard]

In MySQL, I need to know how to create a row in a table that is an
auto_increment and starts at a certain number.  I've tried using:

CREATE TABLE something (
id_number    int     default '5000'    auto_increment,
UNIQUE id_number (id_number)
);

but it sets the default to NULL.  How do I do that?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]