I have a table with 3 columns (id, text, and status) the id is primary key and is set to auto increment. When I delete a record (say record 3) and I have 5 record total, I am left with a gap in the id column. Is there a way to stop this? So when 3 is deleted, 4 becomes 3 and 5 becomes 4.
Brendan.
