1.php
$conn->autocommit(false);
$conn->rollback();
$conn->commit();
$conn->autocommit(true);
2.mysql
begin
update ...
rollback
commit
3.mysql
set autocommit=0
update ...
rollback
commit
set autocommit=1