Deletes all data rows from the selected database
table that match the values of a row from the selected KNIME input table columns.
All selected column names of the KNIME table need to exactly match the column names inside the database.
Only the rows matching all values of the selected column of any given input row will be deleted.
The column order of the KNIME table and the database table do not need to match.
The output table contains two additional columns if Append delete statuses checkbox is checked.
The first extra columns is the number of rows affected by the DELETE statement. A number greater than or
equal to zero -- indicates that the command was processed successfully and is an update count giving the
number of rows in the database that were affected by the command's execution. A value of -2 -- indicates that
the command was processed successfully but that the number of rows affected is unknown. The second shows
a warning message, if any.
Options
Settings
Output Type Mapping
This tab allows you to define rules to map from KNIME types to database types.
Popular Successors
- DB Insert16 %
- DB Writer5 %
- MySQL Connector4 %
- Loop End3 %
- Column Filter3 %
- Joiner3 %
- DB Merge3 %
- DB Update2 %
- GroupBy2 %
- Microsoft Access Connector2 %
- DB Connection Closer2 %
- DB Delete (Table)2 %
- DB Reader2 %
- DB Connection Extractor2 %
- Variable Loop End2 %
CASE Switch Variable (End)2 %- End IF2 %
DB Loader2 %Database Delete1 %- Concatenate1 %
Row Filter (deprecated)1 %Column Rename1 %- Math Formula1 %
- Excel Writer1 %
Joiner1 %- DB Delete (Filter)1 %
- Parameterized DB Query Reader1 %
- DB Query1 %
- Wait...< 1 %
Loop End< 1 %- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- Rule-based Row Filter< 1 %
- DB Loader< 1 %
- DB Query Reader< 1 %
- DB SQL Executor< 1 %
- DB Joiner< 1 %
- DB Table Selector< 1 %
- Counter Generation< 1 %
- Try (Data Ports)< 1 %
CSV Writer< 1 %- String Manipulation< 1 %
Merge Variables< 1 %- Date&Time Shift< 1 %
Table Row To Variable Loop Start< 1 %- Cross Joiner< 1 %
DB Table Creator< 1 %- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Data to Report (BIRT)< 1 %
- CSV Writer< 1 %
Recursive Loop End< 1 %Variable Loop End< 1 %- Rule Engine< 1 %
- Cache< 1 %
- DB Column Filter< 1 %
- DB Transaction End< 1 %
- DB Query Extractor< 1 %
Flow Variable End IF< 1 %Loop End (3 ports)< 1 %- Breakpoint< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Database Writer< 1 %- Variable Condition Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- X-Aggregator< 1 %
- Add Empty Rows< 1 %
- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %- Row Filter (Labs)< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Merge Variables< 1 %
- Timer Info< 1 %
- Interactive Table (legacy)< 1 %
- DB Connection Table Writer< 1 %
- DB Type Mapper< 1 %
- DB GroupBy< 1 %
- Math Formula (Variable)< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Table to JSON< 1 %
- Python Script (legacy)< 1 %
Views
- This node has no views
Workflows
00_Setup_SQLite_DBKNIME Hub- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- 00_Setup_SQLite_DBKNIME Hub
- Show all 47 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.