UPDATE Product_ID to create consecutive IDs

[emalex87]

Hi, My Product_ID column on table vm_product has some holes on it, due to deleting some items. IDs are like this: 1, 2, 4, 7, 11, etc.

I want to set my product IDs back to 1, 2, 3, 4, 6, 7,... how can that be done?