Posted by Jonathan Tremlett on 06/24/05 15:01

I did try this so it definitely works.

Jonathan Tremlett wrote:

> Hi,
>
> This link shall help you:
>
> http://www.electrictoolbox.com/article/mysql/delete-all-data-mysql/
>
> Rather than using delete from table you use another function called TRUNCATE
> TABLE table
>
> Johnny
>
> "Dynamo" <Dynamo_member@newsguy.com> wrote in message
> news:d9ggd20gso@drn.newsguy.com...
>
>>Hi
>>
>>Can somebody please tell me how to reset the auto increment number of a
>
> table to
>
>>zero. I have deleted all the records from the table but auto increment
>
> remains
>
>>at 55.
>>
>>TIA Dynamo
>>
>
>
>

• Next in forum: SELECT one record, or see if it exists
• Prev in forum: Re: Help please with resetting autoincrement to zero
• Thread view: Re: Help please with resetting autoincrement to zero

[Reply to this message]