Reusing a Deleted ID#

Forum Moderators: open

Message Too Old, No Replies

3:45 am on Nov 29, 2006 (gmt 0)

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.

4:10 am on Nov 29, 2006 (gmt 0)

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.

12:19 am on Nov 30, 2006 (gmt 0)

I use mySQL.

Thanks.

1:24 am on Nov 30, 2006 (gmt 0)

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

JAG

1:35 am on Nov 30, 2006 (gmt 0)

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