title: Different mysql Count return value
body: <p>i have the following query </p>
  
  <p><code>SELECT count( * ) COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'ptbs.ms_karyawan'</code></p>
  
  <p>and execute them on mysql wamp, it returns 2 columns</p>
  
  <p>but then, when i execute the query above using C#, it returns -1 columns, here is the code</p>
  
  <pre><code>  private void button1_Click(object sender, EventArgs e)
      {
          int table = dbc.Count("ptbs.ms_karyawan");
          msg.Sukses("Jumlah table adalah :"+table, "Login");
      }
  </code></pre>
  
  <p>and here is the <code>dbc.count()</code> code</p>
  
  <pre><code>  public int Count(string table_name)
      {
          string query = "SELECT count( * ) COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = '"+table_name+"'";
          int table = 0;
  
          if (OpenConnection() == true)
          {
              //create mysql command
              MySqlCommand cmd = new MySqlCommand();
  
              //Assign the query using CommandText
              cmd.CommandText = query;
  
              //Assign the connection using Connection
              cmd.Connection = connection;
  
              //Execute query
              table = cmd.ExecuteNonQuery();
  
              //close connection
              this.CloseConnection();                             
          }
          return table;
      }
  </code></pre>
  
  <p>why did they return different value, though i'm using the same query ? what did i do wrong ? </p>