List:MySQL ODBC« Previous MessageNext Message »
From:Paul DuBois Date:January 29 2003 4:35am
Subject:Re: quick question about
View as plain text  
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

Thread
quick question aboutJacob Devore28 Jan
Re: quick question aboutPaul DuBois29 Jan
RE: quick question aboutJacob Devore29 Jan
Re: quick question aboutSteve Edberg29 Jan
RE: quick question aboutJacob Devore29 Jan