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 Predecessors
Database Connection Table Reader6 %Database Table Selector5 %String To Number5 %Database Reader4 %Variable to Table Row3 %Database Update3 %MySQL Connector3 %Database Delete2 %Database SQL Executor2 %- Java Snippet (simple)2 %
Column Rename2 %- Number Rounder2 %
Row Filter (deprecated)2 %Excel Reader (XLS)2 %Database Writer2 %- Constant Value Column2 %
- Row Sampling2 %
- Math Formula2 %
- DB Delete (Table)2 %
Table Row to Variable1 %- Column Filter1 %
- GroupBy1 %
- String Manipulation1 %
Excel Reader (XLS)1 %Table Row To Variable Loop Start1 %CSV Reader1 %Loop End1 %- Chunk Loop Start1 %
- Reference Row Splitter1 %
Joiner1 %- Rule-based Row Filter1 %
- Rule Engine1 %
CASE Switch Data (Start)1 %- String Manipulation (Multi Column)1 %
- CSV Writer1 %
Parameterized Database Query< 1 %- Reference Row Filter< 1 %
- Partitioning< 1 %
- Split Collection Column< 1 %
Column Appender< 1 %- Microsoft SQL Server Connector< 1 %
- DB Writer< 1 %
- Concatenate< 1 %
- Column Resorter< 1 %
- IF Switch< 1 %
- Copy/Move Files (legacy)< 1 %
Database Query< 1 %- RowID< 1 %
- Sorter< 1 %
- String Manipulation (Variable)< 1 %
- DB Update< 1 %
Variable to Table Column< 1 %CSV Writer< 1 %Database Drop Table< 1 %- Table Creator< 1 %
- Column Renamer (Dictionary)< 1 %
Row Splitter (deprecated)< 1 %Merge Variables< 1 %SQLite Connector< 1 %- Java IF (Table)< 1 %
- Line Plot (JavaScript)< 1 %
Excel Writer (XLS)< 1 %- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Joiner< 1 %
- SDF Reader< 1 %
Database Table Connector< 1 %Database Looping< 1 %Database Connector< 1 %Database Table Creator< 1 %File Reader< 1 %- Java Edit Variable< 1 %
- Java Snippet< 1 %
- Numeric Binner< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- HiLite Row Splitter< 1 %
- Missing Value< 1 %
- Reference Column Resorter< 1 %
- Rule-based Row Splitter< 1 %
- Empty Table Switch< 1 %
PostgreSQL Connector< 1 %Microsoft SQL Server Connector< 1 %Strings To Document< 1 %- String to Date&Time< 1 %
- Create Date&Time Range< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Molecule to CDK< 1 %
- Acoustic Feature Extractor< 1 %
Catch Errors (DB Ports)< 1 %- ARFF Reader< 1 %
Database Column Filter< 1 %- Decision Tree Predictor< 1 %
- Logistic Regression Learner< 1 %
Cell Splitter< 1 %Number To String< 1 %- Create Table Structure< 1 %
- One to Many (PMML)< 1 %
String To Number (PMML)< 1 %- String Replacer< 1 %
- Cache< 1 %
H2 Connector< 1 %- DB Insert< 1 %
- Model Loop End< 1 %
PMML Predictor< 1 %Read Excel Sheet Names (XLS)< 1 %- Spark Line Appender< 1 %
- Google Sheets Reader< 1 %
- Column Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
Python Script (1⇒1)< 1 %Extract Date&Time Fields< 1 %- Modify Time< 1 %
- Table Row to Variable< 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.