mysql5.6升级到5.7报错

Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wanlshop.order.createtime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES