topic write a insert query using a tMysqlRow component? in Talend Studio

write a insert query using a tMysqlRow component?

Anonymous — Sat, 16 Nov 2024 14:09:23 GMT

Query: insert into employee values(name,id) on duplicate key update id=id+1
Job structure: 2 tmysqlInputs to a tMap , leading to a tMysqlRow component
What should be the format of the sql query.

Re: write a insert query using a tMysqlRow component?

Anonymous — Thu, 20 Nov 2008 02:57:44 GMT

any help here?

Re: write a insert query using a tMysqlRow component?

Anonymous — Fri, 21 Nov 2008 22:48:14 GMT

Let's say that the output from your tMap is call "out" and it has two fields/columns- one called v1 (for name column) and one called v2 (for id). The Query in your tMySQL would be:
"insert into employee values("+out.v1+","+out.v2+") on duplicate key update id=id+1"