set @q=concat('select album_id,size into @album_id , @size from ',p_tablename,' where id = ? ');
set @q=concat('select album_id into @album_id,size into @size from ',p_tablename,' where id = ? ');注意你这儿用了个什么符号,注意中文与英文的区别。 set @q=concat('select album_id into @album_id,size into @size from ',p_tablename,' where id = ? ');
Undeclared variable: size第二个参数变量就不对了
Undeclared variable: size