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/02 03:20] (current)
dmitry created
Line 1: Line 1:
 +===== Delete database rows =====
  
 +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.
 +
 +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.
transformations/deletedbrows.txt · Last modified: 2017/05/02 03:20 by dmitry