Answers for "get number of rows in mysql query"

mysql get count of rows

SELECT COUNT(*) FROM my_table;
SELECT COUNT(*) FROM my_table WHERE my_column IS NULL;
SELECT COUNT(*) FROM my_table WHERE my_column = 'my_value';
SELECT COUNT(DISTINCT tel) gender_count,
       COUNT(DISTINCT CASE WHEN gender = 'male'   THEN tel END) male_count,
       COUNT(DISTINCT CASE WHEN gender = 'female' THEN tel END) female_count
FROM people;

Posted by: Guest on April-20-2021

get number of rows in every table mysql

mysql> SELECT table_name, table_rows
   ->FROM INFORMATION_SCHEMA.TABLES
   ->WHERE TABLE_SCHEMA = 'business';

Posted by: Guest on May-20-2020

Code answers related to "get number of rows in mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get number of rows in mysql query"

Code answers related to "get number of rows in mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get number of rows in mysql query"

Code answers related to "get number of rows in mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us