Mysql-phpmyadmin error #1054 Unknown column ' Devison ' in ' order clause '

Today, I looked at the MySQL database and found myself devision a table of Devison.
When I change it, I notice that clicking on the structure of table in phpMyAdmin will jump out of this error: #1054 Unknown column ' Devison ' in ' order clause '. Even if I delete the field to rebuild, the table is deleted and the rebuild is not valid.
Go to StackOverflow and find this problem is very similar to my situation. Direct URL
According to the message under the question, it is found that the default select * FROM TableName of phpMyAdmin will be forced into select * FROM TableName ORDER BY devisonASC LIMIT 0, 25, causes an error.
Now basically can determine is phpmyadmin problem, and then according to StackOverflow answer one of the method test, still exist this problem.
Then the answer is mentioned in the second: then I change the standard SQL time you click on Explore in PhpMyAdmin, but do not know how to modify the standard SQL.
To prevent this problem, a new redundant field of Devison is now created. But how to solve this problem completely or modify the standard SQL?

Attached: Under normal circumstances will not select * FROM tablename forced to select * FROM tablename ORDER by devison ASC LIMIT 0, 25, but delete ' Devison ' will change this.

Reply content:

Today, I looked at the MySQL database and found myself devision a table of Devison.
When I change it, I notice that clicking on the structure of table in phpMyAdmin will jump out of this error: #1054 Unknown column ' Devison ' in ' order clause '. Even if I delete the field to rebuild, the table is deleted and the rebuild is not valid.
Go to StackOverflow and find this problem is very similar to my situation. Direct URL
According to the message under the question, it is found that the default select * FROM TableName of phpMyAdmin will be forced into select * FROM tablename ORDER by devison ASC LIMIT 0, 25, resulting in an error.
Now basically can determine is phpmyadmin problem, and then according to StackOverflow answer one of the method test, still exist this problem.
Then the answer is mentioned in the second: then I change the standard SQL time you click on Explore in PhpMyAdmin, but do not know how to modify the standard SQL.
To prevent this problem, a new redundant field of Devison is now created. But how to solve this problem completely or modify the standard SQL?

Attached: Under normal circumstances will not select * FROM tablename forced to select * FROM tablename ORDER by devison ASC LIMIT 0, 25, but delete ' Devison ' will change this.

Finally fix, immediately feel oneself Meng Meng da.
It is true that the standard SQL is modified. In the search-"+ Options-" Display order you can change it.

