美文网首页
#1055 - Expression of SELECT lis

#1055 - Expression of SELECT lis

作者: 汗青fullstack | 来源:发表于2017-12-06 11:16 被阅读39次

    解决方法:

    进入终端后执行
    mysql -u root -p
    mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
    

    参考:

    #1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

    相关文章

      网友评论

          本文标题:#1055 - Expression of SELECT lis

          本文链接:https://www.haomeiwen.com/subject/cwekixtx.html