Export to mysql table with Replace

1

i am trying to export data into an AWS RDS mysql table. When i do this via sequel pro manually (which i am trying to eliminate with Easymorph) if I leave it as an insert it has issues and it has actually frozen the DB so i have to use an explicit REPLACE Import method. Can i do that with the update? i thought update wouldn’t do insert if record not found.

thanks!

2

Hi Cris,

Yes, the “Update database table” action will not insert new rows.

You can try to emulate the behavior of the REPLACE statement with the consecutive “Delete matching database rows” and “Export into database table” action. Have in mind that such workflow is not transactional.