database:mysql:transaction
差異處
這裏顯示兩個版本的差異處。
| Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
|
database:mysql:transaction [2014/09/09 16:34] ali88 [MySQL交易的隔離層級] |
database:mysql:transaction [2014/09/09 16:53] (目前版本) ali88 |
||
|---|---|---|---|
| 行 1: | 行 1: | ||
| + | ======MySQL交易 未完成====== | ||
| ======MySQL交易的隔離層級====== | ======MySQL交易的隔離層級====== | ||
| ===MySQL提供四種隔離層級=== | ===MySQL提供四種隔離層級=== | ||
| 行 16: | 行 17: | ||
| | | |mysql>select * from QQ;| | | | |mysql>select * from QQ;| | ||
| | | |mysql>commit; | | | | |mysql>commit; | | ||
| - | | |mysql>select * from QQ;|| | + | | |mysql>select * from QQ; | | |
| - | | |mysql>commit;|| | + | | |mysql>commit; | | |
| - | | |mysql>select * from QQ;|| | + | | |mysql>select * from QQ; | | |
| + | |||
| + | ===Read-Committed=== | ||
| + | |||
| + | ^Time ^session1 ^session2 ^ | ||
| + | | |mysql>set tx_isolation='read-committed'; || | ||
| + | | |mysql>show variables like '%iso%'; |mysql>show variables like '%iso%';| | ||
| + | | |mysql>select * from QQ; |mysql>select * from QQ; | | ||
| + | | |mysql>start transaction; |mysql>start transaction; | | ||
| + | | | |mysql>update QQ set data='IIIII' where id=9; | | ||
| + | | |mysql>select * from QQ; |mysql>select * from QQ;| | ||
| + | | | |mysql>commit; | | ||
| + | | |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.1410280494.txt.gz · 上一次變更: 2014/09/09 16:34 由 ali88
若無特別註明，本 wiki 上的內容都是採用以下授權方式： CC Attribution-Share Alike 3.0 Unported
