Answers for "Reorder Table Primary Key Index After Deleting Some Rows"

Reorder Table Primary Key Index After Deleting Some Rows

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

Posted by: Guest on February-16-2022

Code answers related to "Reorder Table Primary Key Index After Deleting Some Rows"