/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 vote157 views1 answer
Learnxinyminutes sql
SQL
0 vote138 views1 answer
Sql server inner join convert collation
SQL
0 vote258 views1 answer
Multiple replace value mssql
SQL
1 vote150 views1 answer
Mysql size int
SQL
15 votes143 views5 answers
If null mysql
SQL
1 vote161 views1 answer
Mysql select and count left join
SQL
0 vote142 views1 answer
Groupby error in mysql
SQL
0 vote145 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote166 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote144 views1 answer
Foreign key type uniqu mysql
SQL