ONLY_FULL_GROUP_BY

关于select字段仅支持group by

1.select   identity from employee group by  identity 
2.select   id,identity from employee group by  identity 
3.select  * from employee group by  identity 
当2.3都失败报错,将ONLY_FULL_GROUP_BY去掉


select @@global.sql_mode

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));