I am trying to do two different queries on a same query using MySQL node. This is something possible on MySQL using a semiclon ( between each query. It looks just like this:
UPDATE comments SET action = "liked" WHERE comment_id = '123';UPDATE users SET likes = likes + 1 WHERE userid = '777';
If i execute this on phpMyAdmin, my MySQL administration tool, it works perfectly. As you can see:
But if I do the exact same query on a MySQL node on n8n, I get an error.
How can I solve this? Thank you!