CREATE PROCEDURE aa(opinion)
begin
create temporary table tmp_aa(name VARCHAR(50) not null);
insert into tmp_aa select distinct vote_user from vote_info where vote_opinion='opinion' order by vote_time desc limit 0,20;
update user set respect=respect+1 where user_name in (select * from tmp_aa);
end;输入到insert行的时候,mysql老是说tmp_aa表不存在,可是这是怎么一回事?明明定义了的啊?????愤怒中
begin
create temporary table tmp_aa(name VARCHAR(50) not null);
insert into tmp_aa select distinct vote_user from vote_info where vote_opinion='opinion' order by vote_time desc limit 0,20;
update user set respect=respect+1 where user_name in (select * from tmp_aa);
end;输入到insert行的时候,mysql老是说tmp_aa表不存在,可是这是怎么一回事?明明定义了的啊?????愤怒中
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货