mysql存储过程 预处理变量

set @isexist=CONCAT('SELECT uid,nickname,phone into @fuid,@fnickname,@fphone ','FROM bbs.pre_ucenter_members WHERE markId="',markid,'" and type=',logtype);
PREPARE data1 FROM @isexist;

EXECUTE data1;

预处理变量无需声明，用来执行拼接好的sql字符串