phpmyadmin无法打开表的浏览视图 [英] phpmyadmin cannot open table's browse view

问题描述

我使用浏览视图在phpmyadmin中打开了一个表，并输入了错误的查询.不幸的是，我在更正视图之前重新启动了浏览器，并且无法打开浏览视图来更正错误.每次打开表格时，都会显示以下弹出窗口:

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

#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.

推荐答案

我知道了.单击表左侧的图标以打开列列表，选择所有列，然后单击已选择"文本旁边的浏览".然后，在页面顶部的sql代码中单击编辑"按钮，然后粘贴:

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 订单COLUMN_NAME DESC

SELECT * FROM TABLE_NAME ORDER BY COLUMN_NAME DESC

这将使该表的默认浏览视图按COLUMN_NAME的降序对表进行排序，从而覆盖损坏的默认排序.我之所以放弃，是因为我花了至少一个小时的时间在google和文档中搜索了一个没有任何运气的解决方案.

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.

这篇关于phpmyadmin无法打开表的浏览视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！