??????MySQL??????????????????????????????????????????????锟�????械??????????COMMIT?????????娲�?????MyISAM??????锟�???????????????????????????????????械???????????
?????????????????????????????????????????????????????ON???????????????娲�?????InnoDB ??????????START TRANSACTION??BEGIN????MySQL??????-????????????????????????????????????COMMIT????????????????????????ROLLBACK ?????????2?????
???????????????????????????OFF????????????SQL??????????????????COMMIT????????????ROLLBACK?????????
???????????????????????ON??????OFF?????????
??????????????????ON
????SET AUTOCOMMIT=0;
??????????????????OFF
????SET AUTOCOMMIT=1;
??????????????????????????OFF??????????????浠�?????OFF?????????user???????????????????????????
????????????????????OFF????薪???????
????mysql> SET AUTOCOMMIT=0;
????Query OK?? 0 rows affected (0.00 sec)
????????user?械?????
mysql> SELECT * FROM user G
*************************** 1. row **************
mid: 1
name: zhangsan
scx: 0
word: NULL
*************************** 2. row **************
mid: 2
name: wangwu
scx: 1
word: NULL
2 rows in set (0.00 sec)