/SQL/Mysql count multiple columns in one query

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` ;

Similar codes

0 vote160 views1 answer
Get only structure database mysql
SQL
0 vote210 views1 answer
Mysql disable triggers
SQL
0 vote130 views1 answer
How to count null values in sql
SQL
0 vote166 views2 answers
Mysql show foreign keys
SQL
5 votes129 views1 answer
List foreign key oracle
SQL
1 vote131 views1 answer
Show table columns
SQL
2 votes130 views1 answer
Sql like variable
SQL
11 votes140 views6 answers
Distinct sql
SQL
5 votes143 views2 answers
Mysql import gzip db
SQL
16 votes142 views3 answers
T-SQL Add Column
SQL