mysql 动态sql,该怎么处理

mysql 动态sqlset @sqlStrselect id,name from sys_users prepare s1 for @sqlStr;execute s1 deallo

mysql 动态sql
set @sqlStr='select id,name from sys_users ';
prepare s1 for @sqlStr;
execute s1 ;
deallocate prepare s1

如何把这个动态sql执行的结果插入到临时表中···求解··各位大侠不吝赐教····谢谢!!

[解决办法]
建议转到mysql板块吧...