[mysql] Create a temp table.. and use it

[Markk]

When you use mysql every node in a workflow sets up its own connection.
But when using temp tables you need the connection from the node that creates the temporary table.

Is there a solution to this, or should I look in a different direction?

[FelixL]

afaik there is no solution for that right now.

I’ve made a feature request for MySQL Transactions a few weeks ago, which in essence also needs MySQL connections to work over multiple nodes:

MySQL add transaction nodes

The idea is: Add transaction features to the MySQL node like BEGIN (start transaction) ROLLBACK COMMIT maybe even add the ability to lock / unlock tables My use case: My use case right now is to update tables without having a few ms between deleting the table and reinserting all rows. But there will be more in depth use cases for me as soon as I create more workflows which communicate with our databases. I think it would be beneficial to add this because: To be able to roll back certain…

[Markk]

That would help a lot indeed!