How to count all rows when using SELECT with LIMIT in MySQL query?

by

What you are looking for is this

SELECT SQL_CALC_FOUND_ROWS A.ID, A.NAME, B.ID, B.NAME
FROM table1 A
JOIN table2 B ON ( A.ID = B.TABLE1_ID )
WHERE
  cond1, cond2, ..., condN
LIMIT 10

SELECT FOUND_ROWS();

More Related Contents:

  1. In SQL Server how to get the count of child if both parent and child are available [closed]
  2. MySQL select 10 random rows from 600K rows fast
  3. Get a list of dates between two dates
  4. How to change max_allowed_packet size
  5. Simulate lag function in MySQL
  6. What does character set and collation mean exactly?
  7. MySQL Split Comma Separated String Into Temp Table
  8. Get record counts for all tables in MySQL database
  9. Query to get all rows from previous month
  10. Use MySQL spatial extensions to select points inside circle
  11. Why can’t a text column have a default value in MySQL?
  12. In SQL, is it OK for two tables to refer to each other?
  13. mysql transaction – roll back on any exception
  14. MySQL create stored procedure syntax with delimiter
  15. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  16. Modeling Product Variants
  17. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  18. MySQL LIKE query with underscore
  19. ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
  20. Compare only day and month with date field in mysql
  21. mysql, ifnull vs coalesce, which is faster?
  22. Pass parameter to MySQL script command line
  23. MySQL delimiter syntax error
  24. Can a MySQL query turn rows into columns?
  25. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  26. GRANT with database name wildcard in MySQL?
  27. Using SUM on FLOAT data
  28. Duplicate entry for key ‘group_key’
  29. SQL query with avg and group by
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment