mysql 如何构造动态语句游标 (不考虑中间表,临时表)
老葱1# 2019-02-18 12:17:17 SET @sqlcmd = concat('select id from ' , table_name, ' where ', filter );
prepare stmt from @sqlcmd;
-- execute stmt;
DECLARE cur1 CURSOR FOR @sqlcmd ; -- FOR execute stmt ;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
就这个意思。
不考虑中间表方案,应为这个函数本身是嵌套的。