Posted by Tony on 06/24/05 19:23

Dynamo wrote:
> 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

TRUNCATE

--
Tony Garcia
Web Right! Development
tony.NO@webrightdevelopment.SPAM.com

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

[Reply to this message]