List:General Discussion« Previous MessageNext Message »
From:Jim McNeely Date:February 23 2011 9:31pm
Subject:Re: auto_increment by more than 1
View as plain text  
This doesn't work, it just sets the starting number, but it will still increment by one
unless you set the auto_increment_increment system variable, but this affects all the
tables in the DB and not just the particular table.

Thanks,

Jim McNeely

On Feb 23, 2011, at 10:26 AM, Carsten Pedersen wrote:

> Den 23-02-2011 18:41, Jim McNeely skrev:
>> 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
> 
> CREATE TABLE t (
> ...
> ) AUTO_INCREMENT=10;
> 
> 
> / Carsten
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

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