MySql Update Query not working, in asp.net

Question

I submit the query, and it doesn't throw an exception, and it does write to the database, but not what I want. For some reason it doesn't touch anything apart from the first thing I tell the query, and sets that to a 0. Here is my code: ``` public static int UpdateTagDefinition(Dictionary<string, object> sqlQueryParams) { MySqlCommand query = new MySqlCommand(); query.CommandText = "UPDATE `windows_dev` SET `name` = @name AND `desc_short` = @desc_short AND `desc_long` = @desc_long AND `tags` = @tags AND `image_title` = @image_title AND `images` = @images AND `release_date` = @release_date AND `update_date` = @update_date AND `is_on_sourcecontrol` = @is_on_sourcecontrol AND `sourcecontrol_type` = @sourcecontrol_type AND `sourcecontrol_uri` = @sourcecontrol_uri AND `download_uri` = @download_uri AND `project_uri` = @project_uri AND `source_uri` = @source_uri AND `is_public` = @is_public WHERE `DID` = @did;"; query.Parameters.Clear(); foreach(var sqlParam in sqlQueryParams) { query.Param…

Accepted Answer

when you want to update multiple columns, use `COMMA` instead of `AND`

```
query.CommandText = @"UPDATE `windows_dev` 
                      SET    `name` = @name, 
                             `desc_short` = @desc_short, 
                             ... other columns .....
                             `is_public` = @is_public 
                      WHERE `DID` = @did"; 
```

MySql Update Query not working, in asp.net

Solution

Problem