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

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

------解决方案--------------------
set @sqlStr='insert into 临时表 select id,name from sys_users ';
prepare s1 for @sqlStr；
execute s1 ;
deallocate prepare s1