mysql兼容问题

执行语句如下：  <? "/kf/ware/vc/" target="_blank" class="keylink">vcD4NCjxwcmUgY2xhc3M9"brush:sql;"> SELECT * FROM stud GROUP BY saddress; 显示了如下错误:  ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hncu.stud.sno' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Mysql中错误使用SQL语句Groupby被兼容的情况 再执行此句：  SELECT saddress as 平均年龄 FROM stud GROUP BY saddress; -没有问题 Mysql中错误使用SQL语句Groupby被兼容的情况 然后我们用mysql，再执行前面那句错误的代码：  也就是：  SELECT * FROM stud GROUP BY saddress;

答案来源网络，供参考，希望对您有帮助