Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Update
NodeNode / Sink

DB Update

DB Read/Write Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Data to update in the database
    KNIME data table with the data rows to be updated in the database.
  2. Type: DB Session
    DB Connection
    DB Connection to the database.
Output ports
  1. Type: Table
    Input Data with Update Status
    Input KNIME data table with additional columns providing the number of affected rows in the database and warnings, if checked in the dialog.
  2. Type: DB Data
    DB Data
    DB Data referencing the selected database table.

Extension

The DB Update node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Twitter Data Collection
    Twitter NLP Text processing
    +5
    This workflow is designed to collect and store a sample of tweets on a particular search …
    knime > Examples > 50_Applications > 19_TwitterAnalysis > 01_Collecting_data_from_Twitter
    knime
  2. Go to item
    demo_db_migration
    mraraman > Public > demo_db_migration
    mraraman
  3. Go to item
    demo_db_migration
    mraraman > VSR Workflows > adhocs > demo_db_migration
    mraraman
  4. Go to item
    Demonstrates the use of DB Update and DB Merge
    H2 Update Merge
    +2
    Demonstrates the use of DB Update and DB Merge
    kathrin > Forum Questions > DB-Merge-Update-Write
    kathrin
  5. Go to item
    04 DB WritingToDB Exercise Solution
    Big Data Education
    Big Data Course DB Exercise #4 Solution
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 3_Solutions > 04_DB_WritingToDB
    knime
  6. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > 1. Database_Operations
    jeany
  7. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter2 > 1. Database_Operations
    jeany
  8. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  9. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.5_2022011 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  10. Go to item
    Database Operations
    KNIME Advanced Luck Books Database
    +2
    This workflow shows how to connect to a database and implement SQL queries, as free text …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.6_20220810 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits