https://community.qlik.com/t5/Talend-Studio/tmysql-output-action-on-data/m-p/2295762#M68495 Hello, <BR /> <BR />How I understand it: <BR />- If the record with the key or unique index does not exist in the table the row is inserted. <BR />- If the record with the key or unique index does exist in the table the row with the key or index is updated. <BR /> <BR />Regards <BR />Ondrej Tue, 02 Jan 2018 18:31:15 GMT lojdr 2018-01-02T18:31:15Z https://community.qlik.com/t5/Talend-Studio/tmysql-output-action-on-data/m-p/2295761#M68494 <P>Hi Team</P> <P>&nbsp;</P> <P>In tmysqloutput&nbsp; in Action on data tab i could find&nbsp;<STRONG>Insert or update on duplicate key or unique index&nbsp;</STRONG></P> <P>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.</P> <P>&nbsp;</P> <P>Thanks</P> <P>Saranya.</P> Tue, 02 Jan 2018 17:30:49 GMT https://community.qlik.com/t5/Talend-Studio/tmysql-output-action-on-data/m-p/2295761#M68494 Anonymous 2018-01-02T17:30:49Z https://community.qlik.com/t5/Talend-Studio/tmysql-output-action-on-data/m-p/2295762#M68495 Hello, <BR /> <BR />How I understand it: <BR />- If the record with the key or unique index does not exist in the table the row is inserted. <BR />- If the record with the key or unique index does exist in the table the row with the key or index is updated. <BR /> <BR />Regards <BR />Ondrej Tue, 02 Jan 2018 18:31:15 GMT https://community.qlik.com/t5/Talend-Studio/tmysql-output-action-on-data/m-p/2295762#M68495 lojdr 2018-01-02T18:31:15Z