updateTAB1setID = ID + 1whereID > 4;
update
TAB1
set
where
insertintoTAB1(ID,NAME)values(5,'new_name');
insert
into
TAB1(ID,
NAME
)
values
(5,
'new_name'
);
记得使用事务提交!