title: Unknown column 'count' in 'field list'
body: <p>I try to make a login form in C# with MySQL database but i get this error:
  <strong><em>Unknown column 'count' in 'field list'</em></strong>. What can I do?</p>
  
  <p>Image with error:</p>
  
  <p><img src="https://i.stack.imgur.com/KL6NG.png" alt="enter image description here"></p>
  
  <p>Here is my code:</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Data;
  using System.Drawing;
  using System.Linq;
  using System.Text;
  using System.Windows.Forms;
  using MySql.Data.MySqlClient;
  
  namespace ScoalaIT
  {
      public partial class Form1 : Form
      {
          public Form1()
          {
              InitializeComponent();
          }
  
          private void pictureBox1_Click(object sender, EventArgs e)
          {
  
          }
  
          private void button1_Click(object sender, EventArgs e)
          {
              string myConnection = "server=localhost;database=test;uid=root;password=123456";
              MySqlConnection connection = new MySqlConnection(myConnection);
  
  
              //string StrQuery1 = "Select count from users where user='" + txtUser.Text + "' and parola='" + txtParola.Text + "'";
              MySqlCommand myCommand = new MySqlCommand("Select count from users where user='" + txtUser.Text + "' and parola='" + txtParola.Text + "'", connection);
              //MySqlDataAdapter MyAdapter = new MySqlDataAdapter(myCommand);
              MySqlDataReader myReader;
              connection.Open();
              myReader = myCommand.ExecuteReader();
              int count = 0;
              while (myReader.Read())
              {
                  count++;
              }
              if (count == 1)
              {
                  MessageBox.Show("Ok");
              }
              else
              {
                  MessageBox.Show("Nu ok");
              }
              connection.Close();
          }
      }
  }
  </code></pre>
  
  <p>Thanks!!!</p>