1、解决order by的相关问题

2、ORDER BY clause is not in SELECT list

只要在mysql的配置文件my.cnf中的[mysqld]下添加如下

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION