MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Rich Lafferty Date:February 23 2005 3:15am
Subject:Re: set auto_increment does not work?
View as plain text  
On Tue, Feb 22, 2005 at 03:46:34PM -0600, Scott Purcell <spurcell@stripped>
wrote:
> Hello,
>  
> ALTER TABLE tbl_name AUTO_INCREMENT = 1000
> will start your records at 1000
> 
> But it does not work for myself. How can I get the auto_increment to
> begin at a set starting point? I know I could insert a bogus record,
> but it just seems sloppy.

Does it work if you use MyISAM tables? Just a hunch, based on something
I ran into in 2002:

  http://www.lafferty.ca/stuff/misc/innodb-autoincrement-bug

but never had time/reason to investigate further (MyISAM proved
sufficient in that application). If you can duplicate what I
saw then it might be worth following up with MySQL AB after testing
in the latest MySQL release.

  -Rich

-- 
Rich Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich@stripped -----------+-----------------------------------------------
Thread
set auto_increment does not work?Scott Purcell22 Feb
  • Re: set auto_increment does not work?Rich Lafferty23 Feb
Re: set auto_increment does not work?Heikki Tuuri23 Feb