merge into tb using ta on(tb.id=ta.id)when not match theninsert values(ta.id,ta,name,ta.age)when match thenupdate set name=ta.name,age=ta.age;commit;
