Re: Resetting auto_increment

On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg <ethros@earthlink.net> wrote: >> >>    UPDATE tablename AUTO_INCREMENT=1; > > mysql> update Visit3 auto_increment=1; > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that corresponds to your MySQL server version for the right syntax to use > near '=1' at line 1 > > Same error if auto_increment is in caps. > > What did I do wrong? Sorry, you didn't --- I did. I was working on something for myself simultaneously and somehow crossed wires. My apologies. That's not an UPDATE query, it's an ALTER TABLE query. ALTER TABLE Visit3 AUTO_INCREMENT=1; Again, my apologies. -- </Daniel P. Brown> Network Infrastructure Manager Documentation, Webmaster Teams http://www.php.net/