COUNT(*) from multiple tables in MySQL

by

You can do it by using subqueries, one subquery for each tableCount :

SELECT
  (SELECT COUNT(*) FROM table1 WHERE someCondition) as table1Count, 
  (SELECT COUNT(*) FROM table2 WHERE someCondition) as table2Count,
  (SELECT COUNT(*) FROM table3 WHERE someCondition) as table3Count

More Related Contents:

  1. Complex Count in MySQL
  2. Most efficient way to get table row count
  3. MySql Count cannot show 0 values
  4. Speeding up row counting in MySQL
  5. Order by COUNT per value
  6. Mysql count instances of substring, then order by
  7. mysql: get record count between two date-time
  8. Why the rows returns by “explain” is not equal to count()?
  9. How to get the count of each distinct value in a column? [duplicate]
  10. MYSQL Left Join COUNTS from multiple tables
  11. Count with IF condition in MySQL query
  12. MySQL – Using COUNT(*) in the WHERE clause
  13. How do I add two count(*) results together on two different tables?
  14. Mysql Counting the consecutive rows that match
  15. SQL select only rows with max value on a column [duplicate]
  16. What is the error “Every derived table must have its own alias” in MySQL?
  17. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  18. Generating a series of dates [duplicate]
  19. How to escape single quotes in MySQL
  20. MySQL comparison with null value
  21. Unique constraint that allows empty values in MySQL
  22. Matching all values in IN clause
  23. Multiple select statements in Single query
  24. Syntax error when using except in a query
  25. Easiest way to copy a table from one database to another?
  26. sql like operator on integer
  27. The best way to remove value from SET field?
  28. Trouble with GROUP_CONCAT and Longtext in MySQL
  29. How to pass a variable to a IN clause?
  30. Insert and set value with max()+1 problems

Leave a Comment