MYSQL分组时条件都必须在查询中的设置

MySQL

mysql> SELECT @@sql_mode; ±----------------------------------------------------------------------------------------------------------------------+ | @@sql_mode | ±----------------------------------------------------------------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | ±----------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

SET sql_mode = ‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’