tmysql output action on data

Six Stars

tmysql output action on data

Hi Team

 

In tmysqloutput  in Action on data tab i could find Insert or update on duplicate key or unique index 

I understood the function is similar to insert or update operation but what is exact purpose of having it i have gone though help but still i ave some conflicts can you please make my understanding better on it.

 

Thanks

Saranya.

Eight Stars

Re: tmysql output action on data

Hello,

How I understand it:
- If the record with the key or unique index does not exist in the table the row is inserted.
- If the record with the key or unique index does exist in the table the row with the key or index is updated.

Regards
Ondrej

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download