I have a question hopefully someone can help with.
I have several mysql tables setup with an “id” used as the primary, self incrementing value. After delteting some entries the table goes out of order, for example one table with 60+ entries I deleted id 1, and now the order is 3,2,4 in the beginning. and tables with over 100 entries have an order like 18,19,108,21. is there anyway to fix this or am I stuck with the problem? My main objective is to make it so that when a table is exported to an excel table the id’s are in order. Thanks for any insight.
