注册 登录
编程论坛 MySQL论坛

mysql中存储过程与事务

dingpin 发布于 2008-08-26 21:30, 1981 次点击
例如下:
create procedure trade()
begin
     update account set balance = balance - 100 where uid = 1;
     update account set balance = balance + 100 where uid = 2;
end//

怎么样用事务保证俩SQL语句都执行呢?
期待,高手解决......
1 回复
#2
dingpin2008-08-27 22:38
有没有人会呀?
急呀,版主在不在呀???????
1