/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 vote96 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote115 views1 answer
Mysql show create db
SQL
0 vote103 views1 answer
Oracle sql winter time change
SQL
1 vote96 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote96 views1 answer
Sqldf change user
SQL
0 vote146 views1 answer
Capabilities of sql select statements
SQL
2 votes112 views3 answers
Sql delete duplicate
SQL
4 votes126 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote132 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote98 views1 answer
Best way to bind parameters to SqlCommand C#
SQL