/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 vote196 views1 answer
Query archive mode
SQL
0 vote214 views1 answer
Mysql changer nom table
SQL
0 vote180 views1 answer
Mysql xampp reset root password
SQL
1 vote181 views1 answer
Mysql list bigger table
SQL
0 vote189 views1 answer
Add a new column into table
SQL
6 votes242 views3 answers
Mysql change auto_increment start value
SQL
5 votes219 views1 answer
How to check port number for postgresql
SQL
0 vote187 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
1 vote178 views3 answers
How to get date in sql
SQL
0 vote231 views1 answer
For select oracle
SQL