mysql存储过程[动态sql]

[fashchina]

set aSql="select count(id),sum(price) into tclick,todayTotalrom adnote where 1=1 ";
set @_sSql = aSql;
prepare sqlstmt from @_sSql;
execute sqlstmt;

好象不能执行

[klan]

select count(id),sum(price) into tclick,todayTotalrom adnote where 1=1

你这句直接运行可以嘛？！

[懒得去死]

set @aSql="select count(id),sum(price) into @tclick,@todayTotalrom adnote where 1=1 ";
prepare sqlstmt from @aSql;
execute sqlstmt;

[fashchina]

[Quote=引用 2 楼 yueliangdao0608 的回复:]
set @aSql="select count(id),sum(price) into @tclick,@todayTotalrom adnote where 1=1 ";
prepare sqlstmt from @aSql;
execute sqlstmt;
[/Quote]

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

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

[懒得去死]

[Quote=引用 3 楼 yxhzj 的回复:]
引用 2 楼 yueliangdao0608 的回复:
set @aSql="select count(id),sum(price) into @tclick,@todayTotalrom adnote where 1=1 ";
prepare sqlstmt from @aSql;
execute sqlstmt;


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

因为@tclick我是通过存储过程返回的
[/Quote]


怎么就不能返回了，
你之后
select @tclick;
或者赋给一个OUT 变量就可以了。

[fenlin]

我也碰到这个问题,用杨涛涛的方法就能解决了。