title: c# mysql update single row
body: <p>This is the code. I want it to update this uses 0 and koffekeys, some how it cant look up val..  </p>
  
  <pre><code>     string Query = "UPDATE `users.db`.`userslogged` SET `uses`='0' WHERE `koffekeys`='@val'";
          string constring = "server=127.0.0.1;User Id=root;password=******;Persist Security Info=True;database=users";
          MySqlConnection conDatabase = new MySqlConnection(constring);
          MySqlCommand cmdDataBase = new MySqlCommand(Query, conDatabase);
  
          cmdDataBase.Parameters.AddWithValue("@val", this.textBox1.Text);
  
          conDatabase.Open();
          cmdDataBase.ExecuteNonQuery();
          conDatabase.Close();
      }
  </code></pre>