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