存储过程中的临时表问题
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表不存在,可是这是怎么一回事?明明定义了的啊?????愤怒中