CODE EXAMPLE FOR SQL

Reorder Table Primary Key Index After Deleting Some Rows

UPDATE tbl SET catid = (SELECT COUNT(*) FROM tbl t WHERE t.catid <= tbl.catid);