mysql存储过程[动态sql]解决方法

mysql存储过程[动态sql]

set aSql=”select count(id),sum(price) into tclick,todayTotalrom adnote where 1=1 “;

set @_sSql = aSql; 

 prepare sqlstmt from @_sSql;  

 execute sqlstmt;

 好象不能执行

set @aSql=”select count(id),sum(price) into @tclick,@todayTotalrom adnote where 1=1 “;

 prepare sqlstmt from @aSql;

 execute sqlstmt;

探讨

引用:

set @aSql=”select count(id),sum(price) into @tclick,@todayTotalrom adnote where 1=1 “;

prepare sqlstmt from @aSql;

execute sqlstmt;

您好,这样可以执行,但是无法通过@tclick返回

因为@tclick我是通过存储过程返回的