Mysql (Node) Update

Questions
#1

Hello,

For some reason the MySQL Update function always passes NULL to the output

{
  "nodes": [
    {
      "parameters": {
        "operation": "update",
        "table": "Tasks",
        "updateKey": "action",
        "columns": "`action`, `TaskID2`, `status`, `Code`, `Regions`, `SEV`, `Assigned`, `Onsite`, `actualTitleText`, `Team`, `entry date`, `entry time`"
      },
      "name": "MySQL2",
      "type": "n8n-nodes-base.mySql",
      "typeVersion": 1,
      "position": [
        840,
        400
      ],
      "credentials": {
        "mySql": "MySQL Server"
      }
    }
  ],
  "connections": {}
}
#2

You won’t be getting any data as output when using MySQL Node to Update or Insert. Instead you’ll get successful, unsuccessful.

Example:

 Rows matched: 1  Changed: 0  Warnings: 0
#3

Error: Column 'status' cannot be null
The input data is definitely not null

#4

Allright, So ` cant be used in MySQL Update, Which also means you cant update to columns which have a space in them