网上找了很多 都不靠谱,自己实操一波
1.进入mysql :docker exec -ti 14ea13dd0cf8 /bin/bash
2.输入密码:mysql -uroot -p
3.查看sql_model:SELECT version(),@@SESSION.sql_mode,@@GLOBAL.sql_mode;
此时发现有ONLY_FULL_GROUP_BY
4.执行以下脚本:
SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
5.此时在看sql_model:
6.重启项目即可



