Posted by Jonathan Tremlett on 06/24/05 12:14

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
>

[Back to original message]