this is incompatible with sql_mode=only_full_group_by 博客分类： mysql

mybatis执行GROUP BY类的语句会报错 this is incompatible with sql_mode=only_full_group_by 

 

需要在my.ini中加上

写道

 

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"