www.webdeveloper.com
Results 1 to 2 of 2

Thread: reorder an sql table

  1. #1
    Join Date
    Feb 2006
    Posts
    170

    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?

    e.g. 1,2,3,4,5,6,7,8,9,10

    4,5 deleted

    1,2,3,4,5,6,7,8

    cheers for any help

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles