时间：2021-07-01 10:21:17 帮助过：3人阅读
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();mysql 遍历所有表并条件查询
标签：string inf line info procedure har color eal begin