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.
Updates the data rows in the database with the data values from the input tables. All selected column names need to exactly match the column names from the database. The WHERE column values need to match the row to update; whereas the SET column values are replaced by the input row values.
The output table contains an additional column with 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.
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
Variable Loop End9 %- Constant Value Column5 %
Database SQL Executor4 %- Chunk Loop Start3 %
Database Update3 %Table Writer3 %- Variable Expressions (legacy)3 %
- R Snippet2 %
Database Delete2 %- Unpivot2 %
Concatenate (Optional in)2 %- Send Email2 %
- Data Explorer2 %
Excel Sheet Appender (XLS)2 %- Catch Errors (Var Ports)1 %
Loop End1 %- String Manipulation1 %
- Rule-based Row Splitter1 %
MySQL Connector1 %Excel Writer (XLS)1 %Flow Variable End IF1 %Database Table Selector1 %Database Connector1 %- Loop End1 %
- String Replacer1 %
Variable to Table Row1 %- Cross Joiner1 %
- Empty Table Switch1 %
- End IF1 %
- Interactive Table (legacy)1 %
Database Writer< 1 %Recursive Loop End< 1 %- Concatenate< 1 %
Row Splitter (deprecated)< 1 %Row Filter (deprecated)< 1 %- Rule-based Row Filter< 1 %
CASE Switch Variable (End)< 1 %- Pie chart (legacy)< 1 %
- Parallel Chunk End< 1 %
- Table to HTML String< 1 %
- Wait...< 1 %
CSV Writer< 1 %- Decision Tree Predictor< 1 %
- Double to Integer< 1 %
Rank Correlation< 1 %- Extract Table Dimension< 1 %
Cell Splitter< 1 %Column Appender< 1 %Column Rename< 1 %- Value Counter< 1 %
CASE Switch Data (End)< 1 %- Date&Time Input (legacy)< 1 %
- String to XML< 1 %
- Delete Files (legacy)< 1 %
- Inject Variables (Data)< 1 %
- Table Row to Variable< 1 %
Database Looping< 1 %- Java Edit Variable< 1 %
- Java Snippet< 1 %
Generic Loop Start< 1 %Number To String< 1 %- Table Validator< 1 %
- GroupBy< 1 %
- Rule Engine< 1 %
- Ruleset Editor< 1 %
- Java Snippet Row Filter< 1 %
- String to JSON< 1 %
- Container Output (JSON)< 1 %
- Date&Time Shift< 1 %
- Time Difference (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Catch Errors (Data Ports)< 1 %
- Variable to Table Column< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %CSV Reader< 1 %Database Connection Table Reader< 1 %Database Reader< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %Loop End (Column Append)< 1 %- Group Loop Start< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Column Resorter< 1 %
- Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Partitioning< 1 %
- IF Switch< 1 %
- Cache< 1 %
Merge Variables< 1 %- Timer Info< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- PMML Compiling Predictor< 1 %
Hive Loader (legacy)< 1 %PostgreSQL Connector< 1 %Microsoft SQL Server Connector< 1 %- DB Loader< 1 %
- DB Update< 1 %
- DB Writer< 1 %
- Boosting Predictor Loop End< 1 %
- Math Formula< 1 %
Excel Reader (XLS)< 1 %- Excel Writer< 1 %
- Java Snippet (simple)< 1 %
- Replacer< 1 %
- Strings to Document< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
Views
- This node has no views
Workflows
01_Collecting_data_from_TwitterKNIME Hub- 01_Collecting_data_from_TwitterKNIME Hub
- CHALLENGE-2021.knarKNIME Hub
- CHALLENGE-2021.knarKNIME Hub
- transidentite_memoire2023-otti.e.knarKNIME Hub
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.