/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

1 vote259 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote256 views1 answer
First Step in installing SQL workbench
SQL
1 vote266 views1 answer
Mysql search like order by best match
SQL
0 vote264 views3 answers
Insert query in ci
SQL
50 votes312 views4 answers
Sql alter type of column
SQL
0 vote273 views1 answer
Alter boolean column postgresql
SQL
1 vote255 views1 answer
Mysql view current queries
SQL
0 vote275 views1 answer
T-sql delete view if exists
SQL
0 vote296 views1 answer
Get total and distict row diff in sql
SQL
0 vote245 views1 answer
Mysql workbench primary key
SQL