mysql计算某一列有哪些数据与每个数据的个数 mysql 例如:原始表testbook 列出mysql中某一列数据有哪些,去掉重复的; select name from testbook group by name; 结果1: 列出某一列的数据不重复的数据,并且计算个数; SELECT name ,count( * ) AS COUNT FROM testbook GROUP BY name ORDER BY COUNT DESC; 结果2: