mysql 5.7+版本sql_mode的坑

发布于 2020-08-14  981 次阅读 

select@@sql_mode;
set sql_mode=(select replace(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
set @@global.sql_mode=(select replace(@@global.sql_mode,'ONLY_FULL_GROUP_BY',''));
select@@sql_mode;
SELECT@@global.sql_mode;

With great power there must come great responsibility.