Re: MYSQL start an auto_increment at a certain number
| From: | Hsieh, Wen-Yang | Date: | Fri, 12 Jan 2001 07:16:19 +0000 |
| Subject: | Re: MYSQL start an auto_increment at a certain number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-34215@lists.php.net to get a copy of this message | ||
CREATE TABLE tbl_name
(
id_number int unsigned auto_increment not null primary key
...
)
AUTO_INCREMENT = 5000;
----- Original Message -----
From: "Jared Howard" <webbie@deanox.com>
To: <php-general@lists.php.net>
Sent: Thursday, January 11, 2001 7:35 PM
Subject: [PHP] MYSQL start an auto_increment at a certain number
> 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: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>