问题描述:
Snipaste_2020-06-18_14-46-05.png
解决思路:去掉公用模式(ONLY_FULL_GROUP_BY)值
Snipaste_2020-06-18_14-47-00.png
相关命令:
select @@global.sql_mode
set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
网友评论