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

Source: Internet
Author: User
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.

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.