/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 vote362 views1 answer
Bitmap join index
SQL
0 vote352 views2 answers
Start mysql server using docker
SQL
15 votes356 views6 answers
Laravel db transaction
SQL
0 vote349 views1 answer
Sql last 3 rows
SQL
1 vote336 views2 answers
Regex starts with
SQL
0 vote385 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote374 views1 answer
Mariadb cast to int
SQL
0 vote374 views1 answer
Mysql relationships between tables
SQL
0 vote415 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote352 views1 answer
Convert multiple columns to ROws in sql server
SQL