mysql存储引擎

-常见Innodb，MyISAM,MEMORY

having关键字对分类后的结果再进行条件的过滤

select name,count(1) from user group by id having count(1)>1