MySQL8插入语句用的子查询报错

Question

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模式，还有什么方法吗？

Answer 1

可以写一个临时表再insert