select * from tj_test1;

 

update tj_test1 set name='aaaa' where id=4

 

delete tj_test1;

merge into tj_test1 tt1 

using tj_test tt 

on (tt1.id=tt.id and tt.name='0000') 

when matched then 

update

set  tt1.name=tt.name

 when not matched then 

 insert values(  tt.id,  tt.name)

 where tt.name='0000'