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>
> Hello,
> 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:

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 Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!    |
rich@stripped -----------+-----------------------------------------------
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