transformations:deletedbrows
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: |
+ | ====== | ||
+ | Category: Workflow / External\\ | ||
- | Deletes | + | \\ |
+ | =====Description===== | ||
+ | This action deletes | ||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | Selecting the "Edit query" button opens the Query Editor for selecting the Connector and entering SQL queries. | ||
+ | ^ Setting | ||
+ | |Connector< | ||
+ | |New query|Enter a SQL query defining the rows to be deleted. | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====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: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[: |
transformations/deletedbrows.1493695220.txt.gz · Last modified: 2017/05/01 23:20 by dmitry