mysql中group by的使用

select中的列名必须是group by后面的列名

SELECT address,COUNT(*) AS c FROM sign_event GROUP BY address HAVING c > 3;

如果写成下面这样就会报错

SELECT name,COUNT(*) AS c FROM sign_event GROUP BY address HAVING c > 3;