当运行项目时报错 this is incompatible with sql_mode=only_full_group_by 1、mac命令窗口切到:/usr/local/mysql/bin 2、执行 mysql -u root -p 注:如果提示找不到mysql命令:分别执行 (1)alias mysql=/usr/local/mysql/bin/mysql (2)alias mysqladmin=/usr/local/mysql/bin/mysqladmin 3、执行 SET @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';(上面是改变了全局sql_mode,对于新建的数据库有效,也只是暂时的重启数据库后又会恢复过去) |
|Archiver|手机版|小黑屋|Java源码
( 京ICP备2021015313号 )
GMT+8, 2023-3-28 19:53 , Processed in 0.065232 second(s), 18 queries .
Powered by JAVAYUANMA.COM
Copyright © 2019-2022, Aliyun Cloud.
在线时间:8:00-24:00