List:General Discussion« Previous MessageNext Message »
From:DL Neil Date:December 3 2002 12:08am
Subject:Re: setting auto-increment to start at higher number
View as plain text  
RD,

> How can I set auto-increment in mysql to start counting at say 50000
rather
>  than 1


The manual is your friend.
Enter auto_increment into the search facility. Read 6.5.3 CREATE TABLE
Syntax - which illustrates the answer, or move on to the better description
in the next 'hit' 6.5.4 ALTER TABLE Syntax.

Regards,
=dn

Thread
setting auto-increment to start at higher numberrdkurth2 Dec
Re: setting auto-increment to start at higher numberDL Neil3 Dec