??????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)