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 star
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_numberint default '5000'auto_increment,
UNIQUE id_number (id_number)
);
but it sets the default to NULL. How do I do that?
2 matches
Mail list logo
