Answers for "how to get count of rows for table in mysql"

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

mysql count all table rows

SELECT COUNT(*) FROM count_demos; // Code language: SQL (Structured Query Language) (sql)

Posted by: Guest on August-13-2021

Code answers related to "how to get count of rows for table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to get count of rows for table in mysql"

Code answers related to "how to get count of rows for table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to get count of rows for table in mysql"

Code answers related to "how to get count of rows for table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us