On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg <ethros@xxxxxxxxxxxxx> 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/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
