Sorting table columns in mysql by adminer

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.

adminer_table_select

Now you get some options like – Alter table   |   Default values  |   Select table  |  New item

Select Alter Table and you get a screen like this

adminer

Alright, you pretty know what to do with those up and down arrows now. Don’t forget to save the changes 🙂

Author's gravatar

Md. Mahbubur Rahman

Your email address will not be published. Required fields are marked *