set @sqlselect = concat("SELECT AVG(TYP) INTO @MA_TYP FROM ",
table_name,
" order by id desc limit 14;");
prepare stmt from @sqlselect;
execute stmt;
DEALLOCATE PREPARE stmt;
...全文
1732打赏收藏
请问里面的mysql语句错在哪?我应该怎么修改?
set @sqlselect = concat("SELECT AVG(TYP) INTO @MA_TYP FROM ", table_name, " order by id desc limit 14;"); prepare stmt from @sqlselect; execute stmt; DEALLOCATE PREPARE stmt;