use eepm_push;DROP PROCEDURE IF EXISTS FountTable;delimiter $$create procedure FountTable()begin 	declare TableName varchar(64);            DECLARE cur_FountTable CURSOR FOR SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'msgfor%';	DECLARE EXIT HANDLER FOR not found CLOSE cur_FountTable;    #打开游标    OPEN cur_FountTable;    REPEAT     FETCH cur_FountTable INTO TableName;	 SET @SQLSTR1 = CONCAT('select * from ',TableName,' where appId = ','''','cc055a4d-53b9-4cfc-9f1a-d8bad41b7502','''',' and createTime > ','''','2017-02-23 00:00:00','''');     PREPARE STMT1 FROM @SQLSTR1;      EXECUTE STMT1;          DEALLOCATE PREPARE STMT1;                UNTIL 0 END REPEAT;  #关闭游标  CLOSE cur_FountTable; END $$DELIMITER ; call FountTable();