Ninjakreborn Posted August 4, 2006 Share Posted August 4, 2006 How do you reorganize fields in a tableI have 4 fields, and I want to make the 3rd field up to where the 1st is, it was my primary, I want my primary on top but have never had to change them around before. Quote Link to comment Share on other sites More sharing options...
Wildbug Posted August 4, 2006 Share Posted August 4, 2006 I think that's under the ALTER TABLE syntax in the MySQL manual. There's an option, FIRST|AFTER [COLUMN] that should allow you to switch things around. Quote Link to comment Share on other sites More sharing options...
Ninjakreborn Posted August 4, 2006 Author Share Posted August 4, 2006 can you do it with php my admin also I will check into that for now thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted August 4, 2006 Share Posted August 4, 2006 I doubt that you can actually "move" columns without re-creating them and copying over the data. Quote Link to comment Share on other sites More sharing options...
AndyB Posted August 4, 2006 Share Posted August 4, 2006 Is there any technical benefit to changing the order of the fields? Why would anyone care "what's on top"? Sounds like a disaster in the making to me. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 4, 2006 Share Posted August 4, 2006 Agreed... which explains why there's no ability to do so. Personally, I like the UID first, but who actually cares? There is so little to be gained by a specific order that it's totally irrelevant. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.