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.
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.