select @@global.sql_mode
SET @@GLOBAL.sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
使用group by查询时报错ORDER BY clause is not in GROUP BY..this is incompatible with sql_mode=only_full_grou
最新推荐文章于 2023-09-18 18:00:37 发布
select @@global.sql_mode
SET @@GLOBAL.sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));