Hi.
Is there any way to condense down the primary key of a table if there are missing numbers?
For example, the primary key is a number from 1 to 100 and it has random numbers missing from rows being deleted.
ID DATA
1 codingforums.com
2 codingforums.com
7 codingforums.com
9 codingforums.com

So it would end up reading:
ID DATA
1 codingforums.com
2 codingforums.com
3 codingforums.com
4 codingforums.com

CREATE TEMPORARY TABLE clone LIKE mytable;

INSERT INTO clone
SELECT * FROM mytable;

TRUNCATE mytable;

INSERT INTO mytable ( all, fields, except, auto, increment, field )
SELECT all, fields, except, auto, increment, field
FROM clone
ORDER BY auto_increment_field;

DROP TEMPORARY TABLE clone;

The difficulty with that, if it's not obvious, is that it is slow and clumsy and you better not be making any changes to the table in some other thread while this is going on.