Complete table data synchronization with the merge statement

Merge into [e-mail protected] b using Tb_sys_sqlscripe C on (b.pk=c.pk)  -merge table from center to branch, synchronization is based on two tables Pkwhen Matched  then update set B.sqlscripe=c.sqlscripe,b.author=c.author  --If the PK value is the same, update the value of the specified table to the target table when not matched                                then-if the PK value is different, insert the entire data from the source table into the target table Insert values (c.pk, C.FK, C.createtime, C.lastmodifytime,c.author,c.module, C.deleteflag, c.scripttype); commit;               --Remember to commit after merge, otherwise the change cannot be submitted

Complete table data synchronization with the merge statement