List:General Discussion« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:February 23 2011 8:34pm
Subject:Re: auto_increment by more than 1
View as plain text  
On 2/23/2011 12:41, Jim McNeely wrote:
> Is there a way to set the auto-increment for a particular table to increase by some
> number more than one, like maybe 10?
>
> Thanks in advance,
>
> Jim McNeely


The manual is your friend. Don't be afraid of it :)

http://dev.mysql.com/doc/refman/5.5/en/replication-options-master.html#sysvar_auto_increment_increment

-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Thread
auto_increment by more than 1Jim McNeely23 Feb
  • Re: auto_increment by more than 1Carsten Pedersen23 Feb
    • Re: auto_increment by more than 1Jim McNeely23 Feb
  • Re: auto_increment by more than 1MySQL)23 Feb
Re: auto_increment by more than 1Jim McNeely23 Feb
  • Re: auto_increment by more than 1Reindl Harald23 Feb
Re: auto_increment by more than 1Reindl Harald23 Feb