savepoint

BEGIN:
 update psf_order set `status`=1 WHERE id='1379256482132643841';
 
 SAVEPOINT s1;
 
 SELECT `status` FROM psf_order WHERE id='1379256482132643841';
 update psf_order set `status`=2 WHERE id='1379256482132643841';
 rollback to s1
 SELECT `status` FROM psf_order WHERE id='1379256482132643841';
 commit
 
  SELECT `status` FROM psf_order WHERE id='1379256482132643841';