MySQL node common issues

Here are some common errors and issues with the MySQL node and steps to resolve or troubleshoot them.

Update rows by composite key

The MySQL node's Update operation lets you to update rows in a table by providing a Column to Match On and a value. This works for tables where single column values can uniquely identify individual rows.

You can't use this pattern for tables that use composite keys, where you need multiple columns to uniquely identify a row. A example of this is MySQL's in the database, where you need both the and columns to uniquely identify rows.