/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

5 votes254 views2 answers
Update all rows mysql
SQL
22 votes278 views4 answers
Mysql reset auto increment id
SQL
1 vote306 views2 answers
Postgresql check privileges on schema
SQL
-1 vote270 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote285 views1 answer
Wordpress change http to https phpmyadmin
SQL
5 votes252 views1 answer
Oracle list packages
SQL
0 vote261 views1 answer
Postgresql update to unique
SQL
4 votes273 views1 answer
Oracle select first 10 rows
SQL
0 vote287 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote268 views1 answer
Mysql update from n to 100
SQL