reorder an sql table
i have an sql table with an auto incrementing id field, they may site works is that it needs the numbers to be consecutive and if an entry is deleted it will break this. is there an sql/php way to reorder the numbers to be consecutive again?
cheers for any help
Why would you need to do that? Can you explain the logic that says you need to have consecutive numbers, as that's not how it should be with any application.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)