How to optimize index

vaterlo

I have an 'id' field with unique, primary, auto_increment features.
Some of the id rows are deleted, so next autoindex is greater than the last id number. So is there any way to optimize id with no missing id numbers?

This is important because i have row swapping function which swaps id to move fields up and down, and where there is missing id nothing swaps. Maybe someone can suggest some kind of similiar script which ignores missing id.

Thanks

bad76

Hi,
i think this not possible directly. Autoindex is autoindex.
But you can add a sort field, an integer that you fill with priority.

see you