mysql存储引擎
-常见Innodb,MyISAM,MEMORY
having关键字对分类后的结果再进行条件的过滤
select name,count(1) from user group by id having count(1)>1
-常见Innodb,MyISAM,MEMORY
select name,count(1) from user group by id having count(1)>1
本文标题:mysql
本文链接:https://www.haomeiwen.com/subject/fndaeqtx.html
网友评论