Selecting cols to compare and updating certain cols only
Table T1 has following columns. C1, C2, C3, C4, C5, C6.
I want to compare only C2, C3, C4 columns with destination. I want to synchronize only these columns if they have a different value and ignore C5 and C6. C1 is the primary key.
I want to do it through the API and not the interface. If you can just explain that will be fine, if you have a sample code, that would be even better.
There is some urgency, so if you can expedite it, it will be great.