Hi team,
Could be a bit of a time saver if among the DB Server Connect actions we also have an Insert/Update function.
For Postgres I believe this is called: Upsert (https://www.postgresqltutorial.com/postgresql-upsert/)
For MySql I believe this is called: Insert / Update on Duplicate Key (https://www.mysqltutorial.org/mysql-insert-or-update-on-duplicate-key-update/#:~:text=When%20you%20insert%20a%20new,with%20the%20new%20values%20instead.)
Currently I typically will run an initial query, then an insert/update based on this.
I’m going to be doing this with the Custom Query builder, just thought this could be a nice add-on to the DB actions in SC.
Community Page
Last updated:
Last updated: