How to get number of rows in a table in mysql

Total Post:28

Points:196
C# 
C#
 1406  View(s)
Ratings:
Rate this:

After a sleepless night and run over the StackOverflow I could not find the method (function) that can resolve my problem.

What I wrote is very harder for the server. Is there any more clever way to resolve this problem?

Here my code:

public static int GetIndexLong(string TblName)

{
    int rowsNbr = 0;
    using(MySqlConnection conn = new MySqlConnection(PublicVariables.cs))
    {
        using(MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + TblName, conn))
        {
            conn.Open();
            using (MySqlDataReader reader = cmd.ExecuteReader())
            {
                while (reader.Read())
                {
                    ++rowsNbr;
                }
            }
            return rowsNbr;
        }
    }
}


It does the job but I know it's not the good way.

Working with C# Express 2008 on .NET 4.0.

  1. Post:30

    Points:210
    Re: How to get number of rows in a table in mysql

    Are you looking for count:

    SELECT COUNT(*) FROM TableName

      Modified On Mar-31-2018 05:44:02 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!