读书人

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

发布时间: 2012-03-20 14:01:11 作者: rapoo

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我是通过存储过程返回的

读书人网 >Mysql

热点推荐