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

[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…