mysql统计功能和数据库information_schema/performance_schema

1、去重统计数据表行数：

select count(distinct col_name) from table_name;select count(distinct col_name) from t