MySQL UPDATE node is not updating MySQL table - Is there another way to update my DB?

Questions
,
1

I recently built a workflow on n8n version 1.58.0 and it results that I need to update some data in MySQL table. The workflow is executing fine with no problems, but in my DataBase the data I want to be updated is not being updated. I mean that the update node executes well in my workflow and outputs a succesful status but the data in MySQL table is not showing updated.

I read about the Update node, that this node has some limitations and that will only show success or unsucces status, but I want the data updated be shown in MySQL table.

Here is my workflow:

image
image1485×483 47.4 KB

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hye @FranciscoGonzTiv,

Welcome to the community :raised_hands:

So with the update we show a sucess if MySQL is returning that it did the update and an error if it fails, I am not sure why MySQL would say it has worked when it hasn’t though so there could be something in the data.

You could try Exceute Query instead and write your own query to do the update which may help.

1 Like
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.