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=j...@newcenturydata.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org