Delete matching database rows

[Alilo_Dris]

@Alilo_Dris

updated

does the action 'modify column' update values
into target table i have tried do it but he does not work .thanks a lot.

[andrew.rybka]

The "Modify column" action modifies values inside an EasyMorph table, not a database table.

You were trying to use the "Delete matching database action" but it seems that that action can't be used with MySQL and a large number of rows because it takes too much time for MySQL to execute the DELETE query.

You can try to use a workaround from the following post:

Delete matching database rows

The problem is not in the temporary table itself but in the DELETE query which is executed on the target table and that temporary table. It seems that MySQL doesn’t optimize it good enough and deletes only 15-20 rows per second. As a workaround you can try to: Export the keys which you are trying to match to a temporary table with the “Export to DB” action. Run a custom DELETE SQL query which will delete required rows. Custom SQL can be executed with the “Custom command” mode of the “Database…

[Alilo_Dris]

@andrew.rybka

The “Modify column” action modifies values inside an EasyMorph table, not a database table.

You were trying to use the “Delete matching database action” but it seems that that action can’t be used with MySQL and a large number of rows because it takes too much time for MySQL to execute the DELETE query:

You can try to use a workaround from the following post:

apparently the only method to update on the target table in easymorph is the one I proposed to you in the previous message:
-Import the lines to update in EasyMorph
-Save them in a temporary .dset file
-Update rows in EasyMorph
-Delete rows from the database table
-Export the updated rows in the database table
-Delete the temporary .dset file
here is the link concerned:Updating database rows - #3 by Shaheed_Fazal