基础数据信息
SELECT COUNT(*) AS '用户名的个数' FROM t_user
SELECT COUNT(DISTINCT username) AS '用户名不重复的个数' FROM t_user
基础数据信息
SELECT COUNT(*) AS '用户名的个数' FROM t_user
SELECT COUNT(DISTINCT username) AS '用户名不重复的个数' FROM t_user
转载于:https://www.cnblogs.com/bobi1234/p/7465948.html