database:mysql:transaction
差異處
這裏顯示兩個版本的差異處。
| Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
|
database:mysql:transaction [2014/09/09 16:48] ali88 [MySQL交易的隔離層級] |
database:mysql:transaction [2014/09/09 16:53] (目前版本) ali88 |
||
|---|---|---|---|
| 行 1: | 行 1: | ||
| + | ======MySQL交易 未完成====== | ||
| ======MySQL交易的隔離層級====== | ======MySQL交易的隔離層級====== | ||
| ===MySQL提供四種隔離層級=== | ===MySQL提供四種隔離層級=== | ||
| 行 27: | 行 28: | ||
| | |mysql>select * from QQ; |mysql>select * from QQ; | | | |mysql>select * from QQ; |mysql>select * from QQ; | | ||
| | |mysql>start transaction; |mysql>start transaction; | | | |mysql>start transaction; |mysql>start transaction; | | ||
| - | | | |mysql>update QQ set data='GGGG' where id=7; | | + | | | |mysql>update QQ set data='IIIII' where id=9; | |
| - | | | |mysql>select * from QQ;| | + | | |mysql>select * from QQ; |mysql>select * from QQ;| |
| | | |mysql>commit; | | | | |mysql>commit; | | ||
| - | | |mysql>select * from QQ; | | | ||
| - | | |mysql>commit; | | | ||
| | |mysql>select * from QQ; | | | | |mysql>select * from QQ; | | | ||
| ======參考資料====== | ======參考資料====== | ||
| * [[http://xyz.cinc.biz/2013/05/mysql-transaction.html|MySQL 交易功能 Transaction 整理 ]] | * [[http://xyz.cinc.biz/2013/05/mysql-transaction.html|MySQL 交易功能 Transaction 整理 ]] | ||
database/mysql/transaction.1410281297.txt.gz · 上一次變更: 2014/09/09 16:48 由 ali88
若無特別註明，本 wiki 上的內容都是採用以下授權方式： CC Attribution-Share Alike 3.0 Unported
