CREATE TABLE tbl_name
(
id_number int unsigned auto_increment not null primary key
...
)
AUTO_INCREMENT = 5000;
----- Original Message -----
From: "Jared Howard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
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]
