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;

[解决办法]