Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Delete (Table)
NodeNode / Sink

DB Delete (Table)

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

Deletes 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 inside the database. Only the rows matching all values of the selected column of any given input row will be deleted. 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 delete statuses checkbox is checked. The first extra columns is 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. The second shows a warning message, if any.

Node details

Input ports
  1. Type: Table
    Data to delete from the database
    KNIME data table with the data rows to be deleted from the database.
  2. Type: DB Session
    DB Connection
    DB Connection to the database.
Output ports
  1. Type: Table
    Input Data with Delete 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 Delete (Table) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Sentiment Analysis with Call Workflow - Deployment
    Deep learning Keras Text classification
    +9
    stockdaa > Public > Sentiment_Analysis_Deployment_with_Call_Workflow 1 ExcelV01(5) 2
    stockdaa
  2. Go to item
    Sentiment Analysis with Call Workflow - Deployment
    Deep learning Keras Text classification
    +9
    There has been no description set for this workflow's metadata.
    kathrin > Codeless Deep Learning with KNIME > Chapter_10 > Integrated_Deployment > Sentiment_Analysis_Deployment_with_Call_Workflow
    kathrin
  3. Go to item
    10 - Billing - CargaInicial
    josecarlosmagno > Public > 10 - Billing - CargaInicial
    josecarlosmagno
  4. 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
  5. 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
  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 …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  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 …
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.5_2022011 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  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.6_20220810 > 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.7_20230123 > AdvancedLuck > Chapter2 > 1. Database_Operations
    rs1
  10. Go to item
    Deploying a Deep Learning Model to Classify Reviews in a Database
    Deep learning Keras Text classification
    +9
    This workflow shows how a trained deep learning model can be used to classify new movie r…
    kathrin > Codeless Deep Learning with KNIME > Chapter_10 > Simple_Deployment_Database > Sentiment_Analysis_Deployment
    kathrin
  1. 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