no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+{{ transformations:DeleteDbRowsAction.png}}
+====== DELETE DATABASE ROWS ======
+Category: Workflow / External\\
+\\
+=====Description=====
+This action deletes rows from a database table where the filtering clause of the query is satisfied (i.e. the WHERE statement in the generated SQL). Column selections and other settings of the query are ignored.
+\\
+=====Action settings=====
+Selecting the "Edit query" button opens the Query Editor for selecting the Connector and entering SQL queries.
+^ Setting  ^ Description  ^
+|Connector<sup>*</sup>|Select or create a connector to the database.|
+|New query|Enter a SQL query defining the rows to be deleted.  Queries can be saved as EasyMorph .query files for future use.|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+=====Remarks=====
+Under the hood, rows are deleted using SQL DELETE statement (with the WHERE statement from the query). The operation is //atomic// meaning that either all satisfying rows are successfully deleted, or nothing is deleted (in case of some failure).
+Using a query in the transformation properties has the convenience of previewing what rows will be deleted before actually deleting them.
+Note that this operation can't be undone -- database rows are deleted forever.
+\\
+=====See also=====
+  * [[transformations:sqlcommand|Database command]]
+  * [[transformations:deletedbrowsbykeys|Delete matching database rows]]
+  * [[transformations:updatedb|Update database table]]
+  * [[:connectors|Information on connectors]]