MySQL升级到5.7.16 遇到的第一个问题“[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and“_jin—zzc的博客

升级之后马上体验了一下，执行“UPDATE user_course SET userid = 200 WHERE id = 28;”，结果报[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 这个错误，语句虽然执行成功了，但是出现这个错误，心里也是慌慌的。升级之后马上体验了一下，执行“UPDATE user_course SET us