MYSQL start an auto_increment at a certain number
| From: | Jared Howard | Date: | Fri, 12 Jan 2001 03:35:41 +0000 |
| Subject: | MYSQL start an auto_increment at a certain number | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-34200@lists.php.net to get a copy of this message | ||
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?