2016年4月26日
[mysql] Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'loser.tank_admin.login_ip' which is not functionally dependent on columns in GROUP BY clause; this is
摘要： 执行SQL: SELECT login_name,login_ip,sex FROM tank_admin GROUP BY login_name ; 时抛出异常。 这个sql语句违背了sql_mode=only_full_group_by 。 先看看这个sql_mode=only_full_gro 阅读全文
posted @ 2016-04-26 06:53 snow__wolf 阅读(22510) 评论(1) 推荐(1) 编辑