www.webdeveloper.com
Results 1 to 2 of 2

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

Hybrid View

  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.
    Jon Wire

    thepointless.com | rounded corner generator

    I agree with Apple. Flash is just terrible.

    Use CODE tags!

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