摘要: SET SQL_SAFE_UPDATES=0; update books set free =1, new=1; commit; SET AUTOCOMMIT=1; begin; select free, new from books limit 1; update books set free = 0; select free, new from books limit 1; SAVEPOINT book1; update books set new = 0; select free, new from books limit 1; rollback to book1... 阅读全文
posted @ 2011-09-08 13:53 酱油哥 阅读(474) 评论(0) 推荐(0)