Differences

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

--- transformations:deletedbrows [2017/05/01 23:20] – created dmitry
+++ transformations:deletedbrows [2021/06/21 02:58] (current) – craigt
@@ Line 1: / Line 1: @@
-===== Delete database rows =====
+{{ transformations:DeleteDbRowsAction.png}}
+====== DELETE DATABASE ROWS ======
+Category: Workflow / External\\
-Deletes rows from a database table where the filtering clause of query is satisfied (i.e. the WHERE statement in generated SQL). Column selections and other settings of the query are ignored.
+\\
+=====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).
@@ Line 8: / Line 22: @@
 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]]