On Tue, Dec 14, 2010 at 13:43, Toby Hart Dyke wrote:
>
> Use 'ALTER tablename AUTO_INCREMENT=1' rather than 'UPDATE tablename
> AUTO_INCREMENT=1'.
Yeah, again, my fault. Not enough coffee on this cold (~7F)
winter's day, perhaps.
--
Network Infrastructure Manager
Documentation, Webmaster
On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg 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
> ne
On 12/14/2010 1:02 PM, Ethan Rosenberg wrote:
At 12:38 PM 12/14/2010, Daniel Brown wrote:
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg
wrote:
> Dear List -
>
> Thanks for all your help.
>
> How do I reset auto_increment so that the primary key will start
from 1.
> The primary key is now 24
At 12:38 PM 12/14/2010, Daniel Brown wrote:
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg wrote:
> Dear List -
>
> Thanks for all your help.
>
> How do I reset auto_increment so that the primary key will start from 1.
> The primary key is now 2421. I have deleted all the data in the table and
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg wrote:
> Dear List -
>
> Thanks for all your help.
>
> How do I reset auto_increment so that the primary key will start from 1.
> The primary key is now 2421. I have deleted all the data in the table and
> started over, and the primary key just incr