MySQL8本地数据库,在navicate执行下列语句
INSERT INTO B (cust_no, match_amt_total)
SELECT cust_no, SUM(match_amt)
FROM A
GROUP BY cust_no;
报错:
[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
有什么解决方法?如果不去掉sql_mode模式,还有什么方法吗?