User Tools

Site Tools


transformations:deletedbrows

Differences

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

Link to this comparison view

transformations:deletedbrows [2017/05/01 23:20]
dmitry created
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). 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. 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]]
transformations/deletedbrows.1493695220.txt.gz · Last modified: 2017/05/01 23:20 by dmitry