Re: truncate table-auto increment values

[Dimitris Papageorgiou]

Rick James Wrote:
-------------------------------------------------------
> ALTER TABLE AUTO_INCREMENT=1;
>
> However, beware... There are cases where
> AUTO_INCREMENT values will skip a number. These
> tend to involve situations you have probably not
> encountered yet -- system crashes, concurrent
> INSERTs into the table, ROLLBACKs, etc.

This command you are mentioning above...will I apply whenever I truncate the table or I will set it once and that is that.

Thanks.