Answers for "get number of rows in table 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

return the number of records in a single table mysql

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

Posted by: Guest on August-21-2021

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

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get number of rows in table mysql"

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

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get number of rows in table mysql"

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

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us