mysql 5.7.20 取得动态sql执行结果

1drop procedure test;
2
3delimiter ;;
4CREATE procedure test()  
5--  取动态sql的值
6begin 
7DECLARE  v_sqlcounts  varchar(500);
8DECLARE  recordcount  varchar(500);
9
10set v_sqlcounts = concat('select 44 into @recordcount from dual');  
11set @sqlcounts := v_sqlcounts;  
12#预处理动态SQL  
13prepare stmt from @sqlcounts;  
14execute stmt;  
15deallocate prepare stmt;  
16#获取动态SQL语句返回值  
17set recordcount = @recordcount; 
18SELECT  recordcount;
19end
20;;
21delimiter ;
22
23call test();