打开下图所示命令窗口  命令操作如下： show databases; use test; show tables; user user; set autocommit=false;(或者autocommit=0); update user set balance=balance-500 where id=1; update user set balance=balance+500 where id=2; rollback;都失败 set autocommit=false;(或者autocommit=0); update user set balance=balance-500 where id=1; update user set balance=balance+500 where id=2; commit;都成功