How to consider 2 Columns as "Value of Column to Match On" Mysql update Action

Describe the problem/error/question

I was trying to update a column on my database using MySQL update action in n8n.The update should be happened based on two columns in my database. But I can consider one column to match on in that particular action. How can I use two columns to match on?

Information on your n8n setup

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

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:

hello @Abin_Jilson

Usually the update should be performed based on the row ID, so you should get the row ID at first with the Select operation and then you can use the returned row ID to use later in the Update operation.

1 Like

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