# How can I accomplish on KNIME "INSERT ... ON DUPLICATE KEY UPDATE Statement"?

**URL:** <https://forum.knime.com/t/how-can-i-accomplish-on-knime-insert-on-duplicate-key-update-statement/32016>\
**Category:** KNIME Analytics Platform\
**Created:** [April 8, 2021, 2:56pm UTC](https://forum.knime.com/t/how-can-i-accomplish-on-knime-insert-on-duplicate-key-update-statement/32016 "2021-04-08T14:56:03Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [April 10, 2021, 3:41pm UTC](https://forum.knime.com/t/how-can-i-accomplish-on-knime-insert-on-duplicate-key-update-statement/32016/10 "2021-04-10T15:41:28Z")

</div>

@bilgee I would like to point you to a KNIME-only solution to your task since that might be what you initially asked

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/b/3b9af92fc29e882bdfe3360515d8bb42776ab0b0.png)

Also I created an example using H2 database and Stud\_id as PRIMARY\_KEY and load everything into a new database

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/9/e9d438000eb153846346e7752c7611fdb4952448.png)

> **[Insert update with KNIME only nodes by an ID – mlauber71](https://hub.knime.com/mlauber71/spaces/Public/latest/forum/kn_forum_32016_insert_on_duplicate~j-J13CI0zkl-OzD2)**
>
> Insert update with KNIME only nodes by an ID

---

_[View the full topic](https://forum.knime.com/t/how-can-i-accomplish-on-knime-insert-on-duplicate-key-update-statement/32016)._