On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg <eth...@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.


    Again, my apologies.

</Daniel P. Brown>
Network Infrastructure Manager
Documentation, Webmaster Teams

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to