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.
Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter
celery is tasteless - currently needing some UI time
There are currently 1 users browsing this thread. (0 members and 1 guests)