Question

mysql存储过程，这个错在哪里？

begin
declare cc,aa,bb int default 0;
declare t_error int default 0;
declare CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;

START TRANSACTION;
select guid into aa from mop510_characters.character where name=uname;

if aa=0 then
select @bb:=max(guid) from mop510_characters.item_instance;
set bb=@bb+1;
insert into mop510_characters.item_instance(guid,itemEntry,count) values (bb,"1400001",ucount);

select @cc:=max(id) from mop510_characters.mail;
set cc=@cc+1;
insert into mop510_characters.mail(id,subject,body,hasitems,receiver) values (cc,"标题","内容",1,aa);

insert into mop510_characters.mail_items(mail_id,item_guid,receiver) values (cc,bb,aa);
end if;

if t_error = 1 then
rollback;
else
commit;
end if;
end

Answer 1

我不清楚报错是什么，不过看起来像是 if aa=0 then逻辑判断有问题，这样只有在 select guid into aa from mop510_characters.character where name=uname;查不到数据时才执行后面的insert语句

追问

请问能加QQ吗？这个问题困扰我很久了，帮帮忙吧

追答

297479710，不过白天我上不了QQ，得晚上才能上