MySql版本问题sql_mode=only_full_group_by的完美解决方案
16lz
2021-12-30
1、查看sql_mode
select @@sql_mode
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
set @@sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
更多相关文章
- 'xlargeScreens' in package 'android'
- Android(安卓)版本兼容 — Android(安卓)6.0 和 7.0后获取Mac地
- android“设置”里的版本号
- Android(安卓)version and Linux Kernel version
- opengrok setup on ubuntu for android source code browser
- [RK3399][Android7.1.1] WifiAp:开机默认打开wifi热点
- Android(安卓)Studio bug - attribute 'android:versionCode' no
- Android——开发环境
- android通过ksoap2对webservice的解析