/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 vote224 views1 answer
Updating database in sql
SQL
0 vote188 views1 answer
Is not numeric sql
SQL
0 vote203 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote288 views1 answer
Concat first name and last name in mysql
SQL
24 votes180 views4 answers
Postgres delete database
SQL
2 votes175 views1 answer
Date conversion in mysql column
SQL
7 votes187 views6 answers
Group_concat in mysql
SQL
3 votes164 views2 answers
Postgres download
SQL
0 vote190 views1 answer
Mysqli last row
SQL
0 vote201 views1 answer
Leftjoin in sql
SQL