select point from epq where epqid=@a into @point1;这句有问题
改写成
delimiter $
CREATE trigger sss
after insert on vote
for each row begin
set @point1=0;
set @a=new.epqid;
set @sqlstr = concat(‘select point into @point1 from epq where epqid=’，@a );
prepare stmt from @sqlstr;
execute stmt;
update membershippoint set pointinuse=@point1;
end$
delimiter ;
内容全部来源于网络收集，如有侵权，请联系网站删除！
QQ：24596024