dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: resetting id numbers, is that a common practice?

  1. #1
    Join Date
    Mar 2010
    Posts
    281

    resetting id numbers, is that a common practice?

    Is it a common practice to want to periodically renumber a tables id column (int primary key, auto_increment)?

    meaning that, over time, as some rows get deleted, it would desirable to reset the id's so numbers are not skipped?

    and if so, is there a mysql or PHP function that would do that?,


    thanks for the help

  2. #2
    Join Date
    Jan 2007
    Location
    Wisconsin
    Posts
    2,120
    Not common as far as I've seen. And doing so would normally be a pretty tedious and error-prone process with little to no return on the investment.

    If you're running out of PK's, the "solution" is to convert to BIGINT, GUID, or multipart PK's.

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