Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpmyadmin cannot open table's browse view

I had a table open in phpmyadmin using the browse view, and entered an incorrect query. Unfortunately, I restarted my browser before correcting the view, and I cannot open browse view to correct the error. Every time I open the table, I get the following popup:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEC,x ASC,z ASC LIMIT 0,30' at line 1

Closing this popup by clicking it leaves me on the page I was already on instead of allowing me to correct the error. Please note that I have checked that the table is ok, and that I can open the table in other views and from other programs, meaning this error is an inconvenience, but will not stop me from working all together. Furthermore, no other tables are affected.

like image 736
NickNackGus Avatar asked Jun 12 '14 17:06

NickNackGus


1 Answers

I figured it out. Click the icon to the left of the table to open the list of columns, select all columns, and click "Browse" next to the text "with selected". Then, click the edit button in the sql code at the top of the page, and paste:

SELECT * FROM TABLE_NAME ORDER BY COLUMN_NAME DESC

This will make the default browse view for that table sort the table by COLUMN_NAME in descending order, overwriting the corrupt default sort. I'm leaving this up because I spent at least an hour searching google and the documentation for a solution with no luck whatsoever.

like image 119
NickNackGus Avatar answered Nov 01 '22 01:11

NickNackGus