MySQL Performance: MySQL => Reorder ID column

Members

Help

Home

Home » Performance » MySQL » Reorder ID column

Show: Today's Messages :: Show Polls :: Message Navigator

Reorder ID column [message #1341]

Wed, 30 May 2007 18:44

GeoffreyF67
Messages: 21
Registered: May 2007

Junior Member

Anyone know of an easy way to reorder an PRIMARY auto increment column that has lots of holes in it?

G-Man

G-Man

Report message to a moderator

Re: Reorder ID column [message #1343 is a reply to message #1341 ]

Thu, 31 May 2007 06:50

sterin
Messages: 323
Registered: March 2007
Location: Sweden

Senior Member

Yes, you don't!
That's the purpose of the primary key to hold unique keys.

What is your reason to do this, it looks messy or?
Unless you have a _very_ good reason to do it you generally leave it as it is.

Report message to a moderator

Re: Reorder ID column [message #1351 is a reply to message #1341 ]

Fri, 01 June 2007 05:38

Speeple
Messages: 91
Registered: August 2006

Member

Agree with the above post, and if you reordered a relational table setup the relation ships would have to reflect the changes.

If there are no relationships to be lost, then you could just CREATE TABLE LIKE... called table_new

Then do INSERT INTO table_new (id, column1 ...) SELECT null, column1 ... FROM table_old;

Martin Gallagher | Speeple: The latest news

Report message to a moderator

Re: Reorder ID column [message #1353 is a reply to message #1341 ]

Fri, 01 June 2007 18:52

GeoffreyF67
Messages: 21
Registered: May 2007

Junior Member

LOL. That's a great point.

Upon further reflection I'm going to leave it as it is.

I was looking around and found a link to a way to get random values even when you have gaps so that'll work just fine for me.

And, mostly, this was just a case of "cuz it looks 'bad'" Razz

Thanks!

G-Man

Report message to a moderator

Previous Topic:	Is MySQL Case Sensitive
Next Topic:	Fastest Way to Remove Duplicates

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 8 23:43:19 EST 2009

Total time taken to generate the page: 0.08465 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.