Update or insert rows in mysqloutput

[BNP]

Hi,

I'm new to this talend. I'm using torachleinput component and tlogrow, tmysqloutput component. whatever update or insert done in the oracle database. Those data transfer into the MySQL database. I have update some data in oracle database and also inserted some new rows. But when I'm selected insert or update in action on data, in MySQL. it's not updated and it's inserted as a new record. it's not update exiting record. Can help this

Thanks in advance.

[manodwhb]

do you have key column I'm tmysqloutput component in the schema otherwise it will always inserts.

[BNP]

Hi manodwhb,

thanks for your replaying

Yes, I have selected it. otherwise its giving error. while updating the records

Capture.GIF

[manodwhb]

Do you have primarykey on same key column indatabase side too?

[BNP]

Yes. 

[manodwhb]

Can you share your tmysqloutput schema screenshot ?