RE: [PHP] A MySQL question
| From: | Jon Haworth | Date: | Tue, 01 Oct 2002 13:14:57 +0000 |
| Subject: | RE: [PHP] A MySQL question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-118363@lists.php.net to get a copy of this message | ||
Hi Ed,
> I am creating a MySQL database with a row named
> id which will be my primary key and will be auto
> incremented. I want the value to start at 4000
ITYM "table" not "database", and "column" not "row"...
The query you're after is
ALTER TABLE mytable AUTO_INCREMENT = 4000
Cheers
Jon