[UPHPU] start auto-increment MySQL column on specific number

[Fred Larsen]

ALTER TABLE tbl_name AUTO_INCREMENT = 100
will start your records at 100

ALTER TABLE tbl_name AUTO_INCREMENT = 1000
will start your records at 1000

http://dev.mysql.com/doc/mysql/en/example-auto-increment.html

On Feb 16, 2005, at 8:18 AM, Wade Preston Shearer wrote:

> Is there a way to start auto-increment MySQL column on a specific 
> number? I want it to start at 200 and then auto-increment upward from 
> there.
>
> wade
>
>
> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net