Page 1 of 1

Re-number auto-increment column

Posted: Wed Feb 06, 2008 9:17 pm
by Todlerone
Hello everyone. Thank-you in advance for any input into this post. I know it isn't necessary to do, however, I would like to try renumbering my auto-increment primary key. It is a simple 3-digit number that gets alot of adds, alters and deletes.

:lol:

Re: Re-number auto-increment column

Posted: Thu Feb 07, 2008 1:58 am
by Kieran Huggins
This is a really bad idea - you could easily screw up your database, and you really don't need to.

Re: Re-number auto-increment column

Posted: Thu Feb 07, 2008 10:39 am
by pickle
Unless you're completely emptying that table and all tables that interact with it - don't bother. There's nothing wrong with having a primary key of 40000 (for example).

Re: Re-number auto-increment column

Posted: Thu Feb 07, 2008 10:52 am
by califdon
I'll add my endorsement -- unless you are an experienced professional and know precisely what you're doing (and that seems unlikely, or you wouldn't have asked the question), LEAVE IT ALONE.