You could make the table, then insert a row with the 1000 as the id, and
delete it after you get some other rows in there.
rather messy, but it works.
James
-------------------------
On Mon, 3 Sep 2001 09:14:46 -0500, Neil wrote:
-------------------------
> Hello:
>
> Is there a way to specify a starting value for an auto increment
> column?
>
> I tried this:
> id INTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT
>
> But, that did not work.
>
> Thanks,
> Neil.
>
> --
> Neil Aggarwal
> JAMM Consulting, Inc. (972) 612-6056, http://www.JAMMConsulting.com
> Custom Internet Development Websites, Ecommerce, Java, databases
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php