Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. MySqlCommand cmd = con.CreateCommand();
  2. cmd.CommandText = @"INSERT INTO dict (pre, dist, dict.char, score) VALUES(@pre, @dist, @char, @score) ON DUPLICATE KEY UPDATE score = score + @score";
  3. cmd.Parameters.Add("@pre", MySqlDbType.VarChar, 32);
  4. cmd.Parameters.Add("@dist", MySqlDbType.Int32);
  5. cmd.Parameters.Add("@char", MySqlDbType.VarChar, 1);
  6. cmd.Parameters.Add("@score", MySqlDbType.Double);
  7. cmd.Prepare();
  8.  
  9. cmd.Parameters[3].Value = score;
  10.  
  11. Console.WriteLine(cmd.IsPrepared);
  12. cmd.ExecuteNonQuery();
  13.  
  14. using (MySqlConnection con = new MySqlConnection(@"SERVER=localhost;DATABASE=rb;UID=;PASSWORD=;"))
  15. {
  16. con.Open();
  17.  
  18. using (MySqlCommand cmd = con.CreateCommand())
  19. {
  20. cmd.CommandText = @"INSERT INTO test (test.test) VALUES(?asdf)";
  21. cmd.Prepare(); //doesn't work
  22.  
  23. cmd.Parameters.AddWithValue("?asdf", 1);
  24.  
  25. cmd.ExecuteNonQuery();
  26. }
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement