How can I count the number of rows returned by MySQL Query?

Question

Is there an easier way to do this, besides loading data into a DataTable and using Rows.Count or using MySqlDataReader and iterating over all the given lines?

Answer 1

if you cannot easily change the request

 SELECT COUNT(*) FROM (<your complete query here>) 

Answer 2

You can execute a query, for example:

 SELECT COUNT(*) FROM MyTable; 

Answer 3

You can use the MySQL information function FOUND_ROWS . Just run it right after the SELECT query. Like this:

 SELECT FOUND_ROWS() 

Answer 4

Exec a

 select count(*) from MyTable WHERE <clause> 

and get the result using ExecuteScalar ()