List:General Discussion« Previous MessageNext Message »
From:Tobias Asplund Date:December 15 2003 2:38pm
Subject:RE: SEQUENCES
View as plain text  
On Mon, 15 Dec 2003, Peter Lovatt wrote:
> Try
>
> Insert INTO `table` ( `inc_field` ) values (1000000000)
>
> the auto inc field will then generate the next sequential numbers
>
> HTH
>
> Peter

Or just use

ALTER TABLE table AUTO_INCREMENT=1000000000

That way you don't have to enter a record just to set the AUTO_INCREMENT
value.


Thread
SEQUENCESGraham Little15 Dec
  • Re: SEQUENCESChris Nolan15 Dec
  • RE: SEQUENCESPeter Lovatt15 Dec
    • RE: SEQUENCESTobias Asplund15 Dec
RE: SEQUENCESJay Blanchard15 Dec
RE: SEQUENCESGraham Little15 Dec
RE: SEQUENCESGraham Little15 Dec