- 积分
- 211
- UID
- 3067
- 阅读权限
- 100
- 注册时间
- 2009-10-24
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 2
|
楼主 |
发表于 2009-10-28 21:14:38
|
显示全部楼层
本帖最后由 yinshi 于 2009-10-28 21:15 编辑
createt definner='root'@'loclahost' procedure 'sp_getpresellticket'(in number)
begin
declare p int default 0;
set autocommit =0;
start transaction;
select ifnull(max(id),0) as high
into p
from t_tmpsellticket for update;
set @sql='insert into t_tmpsellticket(pool,ticketid,maxid) select pool,tocketid,';
set @sql=concat(@sql,cast(p as BINARY);
set @sql=concat(@sql,' from t_sellticket where used=0 limit ';
set @sql=concat(@sql,cast(number as BINARY));
prepare stmt from @sql;
execute stmt;
deallocate prepare stmt; |
|