Updates 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 from the database.
The WHERE column values of the input KNIME data row need to match the values of the database row
to update; whereas the SET database column values are replaced by the input KNIME column values.
Only the rows matching all values of the selected column of any given input row will be updated.
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 update statuses checkbox is checked.
The first extra columns is the number of rows affected by the UPDATE 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 Predecessors
Column Rename6 %- DB Writer6 %
Row Filter (deprecated)5 %- Column Filter5 %
- Joiner4 %
- Rule-based Row Filter4 %
- String Manipulation3 %
- Rule Engine3 %
- Constant Value Column3 %
- Excel Reader2 %
- Column Renamer2 %
- Concatenate2 %
- Column Expressions2 %
- DB Insert2 %
- DB Update2 %
- String to Date&Time1 %
- GroupBy1 %
- DB Query Reader1 %
- Duplicate Row Filter1 %
- Table Creator1 %
- Java Snippet1 %
- String to Number1 %
- Microsoft SQL Server Connector1 %
- Date&Time to String1 %
- Table Manipulator1 %
- DB Connector< 1 %
- DB Reader< 1 %
- Cross Joiner< 1 %
- DB SQL Executor< 1 %
DB Table Creator< 1 %- MySQL Connector< 1 %
- Math Formula< 1 %
- Chunk Loop Start< 1 %
- Missing Value< 1 %
- Column Resorter< 1 %
- Rule-based Row Splitter< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- DB Loader< 1 %
- Column Merger< 1 %
- H2 Connector< 1 %
- Oracle Connector< 1 %
- DB Delete (Table)< 1 %
- DB Merge< 1 %
- File Reader< 1 %
- Loop End< 1 %
- String Manipulation (Multi Column)< 1 %
- DB Connection Extractor< 1 %
Column Appender< 1 %Row Splitter (deprecated)< 1 %- SQLite Connector< 1 %
DB Loader< 1 %- UNIX Timestamp to Date&Time< 1 %
- Date&Time Shift< 1 %
- Top k Row Filter< 1 %
- Scorer< 1 %
- Double to Integer< 1 %
- Number Rounder< 1 %
Loop End< 1 %- PostgreSQL Connector< 1 %
- Column Combiner< 1 %
- Create Table Structure< 1 %
- Row Sampling< 1 %
- String Replacer< 1 %
- Try (Data Ports)< 1 %
- CSV Reader< 1 %
- Parallel Chunk End< 1 %
- DB Table Creator< 1 %
- DB Delete (Filter)< 1 %
- Pivot< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- Nominal Value Row Filter< 1 %
CASE Switch Data (Start)< 1 %- Excel Writer< 1 %
- Math Formula (Multi Column)< 1 %
- Column Auto Type Cast< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- RowID< 1 %
- Parameterized DB Query Reader< 1 %
Excel Reader (XLS)< 1 %- Wait...< 1 %
- Column Appender< 1 %
- Reference Column Filter< 1 %
- JSON Path< 1 %
- Create Date&Time Range< 1 %
- Rule Engine (Dictionary)< 1 %
Database Connection Table Reader< 1 %Table Reader< 1 %Cell Replacer< 1 %- Number to String< 1 %
- Column Renamer (Dictionary)< 1 %
- Reference Row Splitter< 1 %
- Sorter< 1 %
- End IF< 1 %
- Microsoft Access Connector< 1 %
- DB Transaction Start< 1 %
- DB Table Selector< 1 %
- Table Editor (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Modify Date< 1 %
- Twitter Search< 1 %
- Variable to Table Column< 1 %
- CSV Writer< 1 %
- Random Forest Predictor< 1 %
- Column Comparator< 1 %
- Row Filter (Labs)< 1 %
- CASE Switch Start< 1 %
- Table View (JavaScript)< 1 %
- Python Script (legacy)< 1 %
- POST Request< 1 %
- Date&Time Part Extractor< 1 %
- Modify Time< 1 %
- Modify Time Zone< 1 %
- Variable Loop End< 1 %
- Column Splitter< 1 %
- DB Row Manipulator< 1 %
- Snowflake Connector< 1 %
- CASE Switch End< 1 %
CSV Reader< 1 %- Table Validator (Reference)< 1 %
- Data Generator< 1 %
- DB Connection Closer< 1 %
- Benchmark End< 1 %
Extract Date&Time Fields< 1 %- Container Input (Table)< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %- Cell Splitter< 1 %
- DB Connection Table Writer< 1 %
- Date&Time Input (legacy)< 1 %
- Table Difference Finder< 1 %
- Ungroup< 1 %
- String to Date/Time (legacy)< 1 %
File Reader< 1 %Generic Loop Start< 1 %Excel Reader (XLS)< 1 %- Scorer (JavaScript)< 1 %
- File Download Widget< 1 %
Flow Variable End IF< 1 %- Table Column to Variable< 1 %
- Amazon Redshift Connector< 1 %
- GET Request< 1 %
SAP Reader (Theobald Software)< 1 %- Date&Time Difference< 1 %
- Mask Date/Time (legacy)< 1 %
Database Reader< 1 %- JSON to Table< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %Variable to Table Row< 1 %Database Update< 1 %List Files< 1 %Table Writer< 1 %Variable Condition Loop End< 1 %- Group Loop Start< 1 %
- Decision Tree Predictor< 1 %
- Regression Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Add Empty Rows< 1 %
Concatenate (Optional in)< 1 %- Number to Category (Apply)< 1 %
- Column Aggregator< 1 %
- Subset Matcher< 1 %
- Missing Value (Apply)< 1 %
- Number to String (PMML)< 1 %
- Reference Column Resorter< 1 %
String Replace (Dictionary)< 1 %- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Conditional Box Plot (legacy)< 1 %
- DB Type Mapper< 1 %
- DB Column Filter< 1 %
- DB Query< 1 %
- DB Query Extractor< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Dictionary Replacer< 1 %
- RegEx Filter< 1 %
- JPMML Cluster Assigner< 1 %
- Value Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
JSON Reader< 1 %Python Script (1⇒1)< 1 %- Twitter Timeline< 1 %
XML Reader< 1 %- String to XML< 1 %
- XPath< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Multiport Loop End< 1 %
- Run Garbage Collector< 1 %
- Strings to Binary Objects< 1 %
Table Row To Variable Loop Start< 1 %- Table Reader< 1 %
- Variable Creator< 1 %
- Java Edit Variable< 1 %
- Polynomial Regression Learner< 1 %
- Denormalizer (PMML)< 1 %
- Rank< 1 %
- Extract Table Dimension< 1 %
- Merge Variables< 1 %
- Google BigQuery Connector< 1 %
- Radar Plot Appender< 1 %
- List Files/Folders< 1 %
- Google Sheets Reader< 1 %
- Refresh Button Widget< 1 %
- R to Table< 1 %
- PUT Request< 1 %
- Latitude/Longitude to Coordinate< 1 %
Views
- This node has no views
Workflows
[01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub- 01_Access_data_from_NoSQL_DB_and_PDFs - SolutionKNIME Hub
- 01_Access_data_from_NoSQL_DB_and_PDFs - SolutionKNIME Hub
- 01_Access_data_from_NoSQL-DB_and_PDFs - SolutionKNIME Hub
- 01_Access_data_from_NoSQL-DB_and_PDFs - SolutionKNIME Hub
- Show all 86 workflows
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.