mysql count multiple columns in one query
mysql count multiple columns in one query: SELECT count(*) as count_rows, count(col1) as count_1, count(col2) as count_2, count(distinct col1) as count_distinct_1, count(distinct col2) as count_distinct_2, count(distinct col1, col2) as count_distinct_1_2 FROM `table` ;