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
>
