mysql错误:this is incompatible with sql_mode=only_full_group_by
来源:原创
时间:2018-11-15
作者:脚本小站
分类:DB
方法一:将select的字段全部包含到 group by 后面
select id title from article group by rand(),id,title;
方法二:改配置去掉 only_full_group_by
my.ini文件 mysql 和 mysqld 中:
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
临时修改:在命令行中
set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';