This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
Deletes data rows in the database based on the selected columns from the input table. All selected column names need to exactly match the column names inside the database. Only the rows matching the values of the selected column will be deleted.
The output table contains an additional column with 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.
If the optional input is connected the database connection information is taken from the port, otherwise you need to specify the connection information in the dialog.
Make sure you have your vendor-specific database driver registered in the KNIME preference page (section Database Driver).
Options
Settings
Column Selection
Advanced
Popular Successors
- Interactive Table (legacy)8 %
Database Delete5 %Database Update4 %- Reference Row Splitter4 %
- End IF4 %
- Wait...3 %
Database Writer3 %- DB Writer3 %
- Delete Files (legacy)2 %
Table Row To Variable Loop Start2 %CSV Writer2 %Database SQL Executor2 %- GroupBy2 %
Database Looping2 %Database Connector2 %- Table Creator2 %
- Column Merger2 %
- String Manipulation2 %
CASE Switch Data (Start)2 %Merge Variables2 %Table Row to Variable1 %Table Reader1 %- Java Snippet1 %
Loop End1 %- Concatenate1 %
- Constant Value Column1 %
Joiner1 %Hive Loader (legacy)1 %Strings To Document1 %- String to Date&Time1 %
Table Column to Variable< 1 %- Cross Joiner< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Rule-based Row Filter< 1 %
CASE Switch Data (End)< 1 %- Send Email< 1 %
- DB Delete (Table)< 1 %
Excel Sheet Appender (XLS)< 1 %- Legacy Date&Time to Date&Time< 1 %
- 2D/3D Scatterplot< 1 %
Database Query< 1 %Database Reader< 1 %Parameterized Database Query< 1 %File Reader< 1 %- Java Edit Variable< 1 %
Loop End (Column Append)< 1 %- Chunk Loop Start< 1 %
Recursive Loop End< 1 %Variable Loop End< 1 %- Linear Regression Learner< 1 %
- String to Number< 1 %
- Filter Apply< 1 %
Row Filter (deprecated)< 1 %- Reference Row Filter< 1 %
- Normalizer< 1 %
Column Rename< 1 %- Rule Engine< 1 %
CASE Switch Variable (End)< 1 %- Conditional Box Plot (legacy)< 1 %
- Molfile Writer< 1 %
MySQL Connector< 1 %- DB Insert< 1 %
- DB Query Reader< 1 %
- Generic Web Service Client< 1 %
- External Tool< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
Python Script (2⇒1)< 1 %- DELETE Request< 1 %
Views
- This node has no views
Workflows
- No workflows found
Links
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.