Re: quick question about

[Paul DuBois]

At 13:23 -0800 1/28/03, Devore, Jacob wrote:
>auto_increment.  Is there a  way to reclaim deleted numbers in a sql
>auto_increment field?

Why bother?

Do you have a good reason to do so?

>   I'm hoping that I don't have to do the work myself.

You can renumber the column by dropping it and adding it.
That's not quite the same as leaving existing numbers alone and
reusing no-longer-used ones.

>
>Thanks,
>
>jake