数据库迁移后,系统原有的sql报错:
of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yj. id' which is not functionally dependent on columns in GROUP BY clause;this is incompatible with sql_mode=only_full_group_by,在网上很快找到解决办法,Mysql版本不一样导致一些配置也不一样,所以修改MySQL配置在/etc目录下vi my.cof 进入配置文件,找到sql_mode=.......
在后面加上‘NO_ENGINE_SUBSTITUTION'
问题解决
看至https://blog.csdn.net/qq_42175986/article/details/82384160
解决this is incompatible with sql_mode=only_full_group_by
最新推荐文章于 2024-09-05 22:15:00 发布