Mysql transaction
来源:互联网 发布:贝克汉姆曼联数据 编辑:程序博客网 时间:2024/05/16 17:22
There's two ways for MYSQL transaction.
1、Use begin,rollback,commit
begin start a transaction
rollback transaction rollback
commit transaction commit
2、Set mysql ini autocommit
In default mysql will commit automatically. It means when you commit a query ,it will excute it directly
set autocommit=0 forbid commit automatically
set autocommit=1 allow commit automatically
Note : In mysql only INNODB and BDB engine support transaction (or other new storage engineer too).
Chang type of mysql engine
table table_name type=InnoDB;
alter table table_name engine=InnoDB;
Transaction example
BEGIN;
SELECT book_number FROM book WHERE book_id = 123 for update;
// ...
UPDATE book SET book_number = book_number - 1 WHERE book_id = 123;
COMMIT;
START TRANSACTION;
SELECT balance FROM checking WHERE customer_id = 10233276;
UPDATE checking SET balance = balance - 200.00 WHERE customer_id = 10233276;
UPDATE savings SET balance = balance + 200.00 WHERE customer_id = 10233276;
COMMIT;
Some sql engine don't support transaction we can use table lock
support MyISAM & InnoDB ,
LOCK TABLES `user` WRITE;
INSERT INTO `user` (`id`, `username`, `sex`) VALUES (NULL, 'test1', '0');
UNLOCK TABLES;
- Mysql transaction
- mysql transaction
- mysql transaction
- MySQL Transaction
- Mysql的transaction实现
- Distributed Transaction Processing:mysql
- MySQL的Transaction
- MySQL: mini-transaction简析
- MYSQL事务(transaction)
- mysql transaction(事务)
- MYSQL 事务transaction 总结
- mysql事务(Transaction)介绍
- ORACLE VS. MYSQL TRANSACTION ISOLATION
- mysql中transaction的实现
- Play framework JPA Transaction MySql
- MySQL存储过程 事务transaction
- MySQL存储过程 事务transaction
- mysql事务(mysql TRANSACTION)(一)
- 用JS+DIV实现类似confirm的提示框
- iphone push notification 消息推送
- 如何对pHPwin进行二次开发!
- Linq to xml 读取xml文件
- 我到底想要什么
- Mysql transaction
- 五种方法开启3389
- JAVA高级视频_网络编程_收获二
- loadrunner 迭代的含义
- android中点中overlay弹出带尾巴的气泡的实现
- 关于自动取款机前安装一个人脸识别机器的需要讨论
- 在VBA操作Excel单元格的方式小结
- 内联汇编调用WINAPI函数调用类函数
- 网络监控软件