360SDN.COM

首页/MySQL/列表

mysql8 ERROR 3065 (HY000): Expression of ORDER BY clause is not in SELECT list

来源:  2018-09-13 13:48:13    评论:0点击:

ERROR 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column  which is not in SELECT list; this is incompatible with DISTINCT  mysql8报错

解决办法:

在linux环境的mysql8配置文件/etc/mysql/my.cnf 中加上以下这句:
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
重启mysql
为您推荐

友情链接 |九搜汽车网 |手机ok生活信息网|ok生活信息网|ok微生活
 Powered by www.360SDN.COM   京ICP备11022651号-4 © 2012-2016 版权