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 ( 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:
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!