begin select * from shop where id =1 for update; update shop set username = '123' where id = 1 ROLLBACK