本文介绍了如何在mysql中的execute语句后存储值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

set @ sqlquery1 = concat(从table1中选择不同的element_name);
从@ sqlquery1准备stmt1;
执行stmt1;
取消分配准备stmt1;

我的问题是,如何将execute stmt1的结果存储在变量中作为字符串...
@ @ sqlquery1其返回olny一行.


在此先感谢...

set @sqlquery1=concat(select distinct element_name from,table1);
prepare stmt1 from @sqlquery1;
execute stmt1;
deallocate prepare stmt1;

my qustion is that how to store the result of execute stmt1 in variable as string ...
@ @sqlquery1 its return olny one row.


thanks in advance...

推荐答案

set @sqlquery1=concat(select distinct element_name from,table1);
prepare stmt1 from @sqlquery1;
execute stmt1;
deallocate prepare stmt1;




以上陈述使用的语言.在asp.net或其他语言中??




In which language you have written above statements. In asp.net or some another language ??


这篇关于如何在mysql中的execute语句后存储值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-20 21:12