I’m looking into using KNIME for some database operations. It appears that in order to carry out an UPDATE operation on a row in a database, I would need to read in the entire table from the database, identify and modify the row I’m interested in, and then overwrite the entire table in the database.
Similar logic would appear to apply when trying to DELETE rows: I would read in the entire table, remove the rows I wished to delete, then overwite the entire table in the database.
Is this correct, or am I missing / misunderstanding some of the database nodes? Thank you in advance.