ONLY_FULL_GROUP_BY问题硬解

select @@global.sql_mode
select @@SESSION.sql_mode

set @@global.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

set @@session.sql_mode= 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'


flush privileges
上一篇:避免 全表扫描 full table scan


下一篇:SQL中关于Join、Inner Join、Left Join、Right Join、Full Join、On、 Where区别