/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 vote190 views1 answer
Mysql select where field is a value
SQL
0 vote213 views4 answers
Restart MySQL
SQL
0 vote201 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
6 votes224 views2 answers
Subtr Oracle ?
SQL
0 vote186 views2 answers
How to find max and min salary in sql
SQL
0 vote189 views4 answers
Forenkey code alchemy sql
SQL
0 vote221 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote219 views1 answer
Find size of all DB's postgres
SQL
0 vote181 views1 answer
Declaring variables in pl sql
SQL
3 votes225 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL