Sorting columns in a mysql table has always been a nasty way to deal with. It can be done some sql commands of course but this is not what we do more often. Even the most popular DB admin package – phpmyadmin doesn’t provide such utility to sort or re-arrange fields in mysql. It occurred to me a lot of times that i had to bring some filed to a different position for convenience after i first created it. But i had to run some queries which i never liked, to do this task.
So ADMINER (formerly phpminadmin) comes up with a nifty utility in their one file standalone package.
If you haven’t heard of Adminer yet (you must have missed a great tool), download from http://www.adminer.org/en/
And run it from your web server from any location. After entering credentials and selecting database, just select a table from the left which appears like this.
Now you get some options like – Alter table | Default values | Select table | New item
Select Alter Table and you get a screen like this
Alright, you pretty know what to do with those up and down arrows now. Don’t forget to save the changes 🙂