MySQL查询去重 方法一: distinct select count(distinct CName) from Course 方法二: 使用分组 group by select count(1) from Course group by CName