....
....
....
declare cnt_model int default 0;set @stmt2 = concat("select count(1) from WareModel where TypeID = '", @t_typeid, "' into @t_model");
prepare s2 from @stmt2;
execute s2;
DEALLOCATE PREPARE s2;
set @stmt2 = NULL;请问,如何把@t_model赋给cnt_model?while i_model < cnt_model DO
...
...
...
....
....
declare cnt_model int default 0;set @stmt2 = concat("select count(1) from WareModel where TypeID = '", @t_typeid, "' into @t_model");
prepare s2 from @stmt2;
execute s2;
DEALLOCATE PREPARE s2;
set @stmt2 = NULL;请问,如何把@t_model赋给cnt_model?while i_model < cnt_model DO
...
...
...
不用拼动态sqlselect count(1) from WareModel where TypeID =@t_typeid into @t_model
set cnt_model =@t_model