Multiple queries on same line on a MySQL node doesn't work

問題
1

Hello,
I am trying to do two different queries on a same query using MySQL node. This is something possible on MySQL using a semiclon (:wink: 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:

phpmyadmin
phpmyadmin1148×727 67 KB

But if I do the exact same query on a MySQL node on n8n, I get an error.

error
error731×478 48 KB

How can I solve this? Thank you! :slight_smile:

2

Hey @ruccc!

I can confirm that you can not run multiple queries currently in the node. You will have to use a separate MySQL node to do this.

Do you think it should be allowed to execute multiple queries in a single node? If yes, can you please create a feature request :slight_smile:

Also, instead of using the Execute Query operation, you can use the Update operation to update the values.

3

Thanks! Good to know.

No problem using separate nodes. I was just wondering if maybe using multiple nodes makes the execution of the workflow longer than if it was all the queries in only one node. Sometimes quickness (even miliseconds) is important!

If it is so, I would gladly create a feature request! :slight_smile: