MySql Get Rows

private int GetTableRows()
{
    int rows;
    using(MySqlConnection con = new MySqlConnection(CONNECTION_STRING))
    using(MySqlCommand cmd = new MySqlCommand())
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandText = "SELECT * FROM myTable";

        rows = int.Parse(cmd.ExecuteScaler().ToString());
    }

    return rows;
}