Reusing a Deleted ID#

[galileo5]

Good evening.

My database has skipped an ID# b/c I deleted an entry. Is there a way to reuse that deleted ID#?

If so, how?

Thank you.

[phranque]

greetings galileo5:

you didn't mention which db you are using, but it may be possible to explicitly set the id in the insert statement.

[galileo5]

I use mySQL.

Thanks.

[justageek]

As phranque said you can just insert a record with the missing id.

JAG

[phranque]

it is certainly possible in mysql - i've done it myself...