Why would you want to re-use the deleted ID?
That would be a poor design.
When you insert a new record with an autoinvcrement, last_insert_id()
will tell you what it
is so you can insert it in dependent tables.
Fates wrote:
>
> I am trying to understand references in tables and using primary ke
I am trying to understand references in tables and using primary keys with
auto increment option as a reference to all tables:
What is the best way to reference other tables? I have three tables:
menus, categories, and links. I also have an ID field in each table that
uses the autoincrement opt