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 -----------+-----------------------------------------------