mysql 游标 运行数据没反应
小当家e 2017-12-01 02:28:12 BEGIN
declare v_table_name varchar(255);
declare done int default 0;
declare cur cursor for
select t.table_name
from INFORMATION_SCHEMA.tables t
where t.table_schema='excrawler'
and instr(table_name,'ex_dc_tmsf_')>0
and instr(table_name,'2017')>0
and substr(table_name,instr(table_name,'2017'),8)<= date(date_add(SYSDATE(), interval -1 month))+0
and table_name !='ex_dc_tmsf_house_info_20170420101032'
order by substr(table_name,instr(table_name,'2017'),8) asc;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
open cur; /*打开游标*/
REPEAT
fetch cur into v_table_name;
if not done then
DROP TABLE IF EXISTS v_table_name;
end if;
until done end repeat;
CLOSE cur; /*关闭游标*/
END
然后用call sp_event_delete(); 调用,运行结果成功,但一张表都没删。
我的游标 里面的sql 有180条数据,我单独拉出来执行过。