mysql之ONLY

xiaoxiao2021-02-28  119

问题: mysql 语句查询时: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: In aggregated query without GROUP BY, expression #25 of SELECT list contains nonaggregated column ‘nybx.l.PUSH_TIME’; this is incompatible with sql_mode=only_full_group_by错误

解决办法下my.cnf(windows下是my.ini)加以下行 [mysqld] sql_mode=’STRICT_TRANS_TABLES,NO_ZERO_IN_DATE, NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’

转载请注明原文地址: https://www.6miu.com/read-68817.html

最新回复(0)