Menu
As the default setting the table showed unsorted. If I eventually click any column the table will be sorted by ascending of this column. Everything what I can do later on is to pick another column or change the ordering direction (from ascending to descending and vice versa)
I can not figure out how to skip ordering at all.
827
If the ASC or DESC modifier is not provided in the ORDER BY clause, the results will be sorted by expression in ascending order. This is equivalent to ORDER BY expression ASC . The ORDER BY clause can be used in a SELECT statement, SELECT LIMIT statement, and DELETE LIMIT statement in MySQL.
Click on the table you wish to modify. Inside the table, you will see a list of columns. To the right of the column name, you will see a link called "Change" under the Actions. Click on the Change link for the column you wish to modify.
From the phpMyAdmin home page, go to Settings > Main panel > Browse mode (or Settings > Main frame for old versions), and uncheck the option Remember table's sorting, then click Save.
Then when browsing a table you can sort the columns as usual, but clicking Browse again will remove the sorting.
Tested on versions 3.5.2.2 and 4.0.10.14.
160
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
