merge into 

merge into t2

using t1

on t2.id=t1.id

when matched then 

update t2.name=t1.name

　　

posted @ 2019-07-12 11:41  不像程序员  阅读(136)  评论(0)    收藏  举报