mysql返回行数,如何计算MySQL查询返回的行数？

How can I count the number of rows that a MySQL query returned?

解决方案

Getting total rows in a query result...

You could just iterate the result and count them. You don&＃39;t say what language or client library you are using, but the API does provide a mysql_num_rows function which can tell you the number of rows in a result.

This is exposed in PHP, for example, as the mysqli_num_rows function. As you&＃39;ve edited the question to mention you&＃39;re using PHP, here&＃39;s a simple example using mysqli functions:

$link &＃61; mysqli_connect("localhost", "user", "password", "database");

$result &＃61; mysqli_query($link, "SELECT * FROM table1");

$num_rows &＃61; mysqli_num_rows($result);

echo "$num_rows Rows\n";

Getting a count of rows matching some criteria...

Just use COUNT(*) - see Counting Rows in the MySQL manual. For example:

SELECT COUNT(*) FROM foo WHERE bar&＃61; &＃39;value&＃39;;

Get total rows when LIMIT is used...

If you&＃39;d used a LIMIT clause but want to know how many rows you&＃39;d get without it, use SQL_CALC_FOUND_ROWS in your query, followed by SELECT FOUND_ROWS();

SELECT SQL_CALC_FOUND_ROWS * FROM foo

WHERE bar&＃61;"value"

LIMIT 10;

SELECT FOUND_ROWS();

For very large tables, this isn&＃39;t going to be particularly efficient, and you&＃39;re better off running a simpler query to obtain a count and caching it before running your queries to get pages of data.