1. 使用 navicat 修改
2. 进入命令行界面 (F6)
3. 输入: SELECT @@GLOBAL.sql_mode;
4. 结果: 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
5.
6. 然后我们来修改 sql_mode
7. 输入: set GLOBAL sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
8.
9. 再运行你的 sql:
- SELECT
- id,ip
- FROM
- ip_meta_backup
- GROUP BY
- ip
- HAVING
- count(ip)> 1
18.***** 恭喜你, 成功了 *****
来源: http://www.bubuko.com/infodetail-2735202.html