Question 209904 in Mysql Question posted in
The official MySQL documentation can be found here.

Error: MySQL – Operand should contain 1 column(s)

This query works when I type directly into mysql but not in C#.

double deltaTime = (DateTime.Now - collectTime).TotalSeconds;


string query = String.Format("UPDATE buildings LEFT JOIN server_buildings ON buildings.global_id = server_buildings.global_id AND buildings.level = server_buildings.level SET buildings.storage = buildings.storage + (server_buildings.speed * {0} * IF(buildings.boost >= NOW(), 2, 1)) WHERE buildings.global_id IN('generator', 'test')", deltaTime / 3600d);

Only get the error MySQL – Operand should contain 1 column(s)
Appreciate suggestions! 🙂

Expected that over time it would add value in "storage"

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Found the solution. Was that my system language is not English. The solution was:

    (deltaTime / 3600d).ToString("F7").Replace(",", ".")

  2. 0

    Thanks, appreciate all the help! Im fairly new to mysql.
    Here it is with parameters.

                string query = String.Format("UPDATE buildings JOIN server_buildings ON buildings.global_id = server_buildings.global_id AND buildings.level = server_buildings.level SET buildings.storage = buildings.storage + (server_buildings.speed * ?Num * IF(buildings.boost >= NOW(), 2, 1)) WHERE buildings.global_id IN('generator', 'test')");
                     
            using (MySqlCommand command = new MySqlCommand(query, connection))
            {
                MySqlParameter param = new MySqlParameter("?Num", (deltaTime / 3600d));
                command.Parameters.Add(param);
      
               command.ExecuteNonQuery();
            }
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search