how to use the database looping ang database update node

can you help me?

How to correctly use  database looping and database update nodes. you can get me a damo.

I created one workflow :

database reader -> database update 

the console prompt WARN Database Update SET and WHERE column list contain duplicate columns.  and the database update node is not configer.

 

by the way , the database reader 's configuration :

database url : jdbc:postgresql://127.0.0.1:6453/xtest

sql statement : select * from t5

can you help me ?

 

 

In the Database UPDATE node you need to select (include list) two distinct columns in the SET and WHERE column list. Hope this helps?