in reply to
Re: mysql auto_incremented id
in thread mysql auto_incremented id
Not sure this is the best solution,
Removing a primary key and recreating it will break
the database referential integrity.
BTW reusing the gaps in the primary key, as the OP wants,
is not the smartest move either. I know a couple of methods
to achieve that, but I also know half a dozen reasons not to
do it. Therefore I'll keep the method for myself.
In the meantime, I will just suggest leaving the primary key alone.