Mysql (Node) Update


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": [
      "credentials": {
        "mySql": "MySQL Server"
  "connections": {}

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


 Rows matched: 1  Changed: 0  Warnings: 0

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

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