I have a table column which is a INT and represents a sequence number for the output of the records from that table.
when I delete some records the seq nos will be for example, 1, 3, 7, 8, 9
I need your advice on what sort of query I need to make them again read like 1,2,3,4,5
I can identify the rows which exists and which have a sequence number
where business_id = 2
which can return 1, 3, 7, 8, 9
How to reset them (consecutively) to 1, 2, 3, 4, 5 is what i need help with please.