mysql 遍历所有表并条件查询

最新推荐文章于 2024-07-18 04:05:48 发布

weixin_33711647

最新推荐文章于 2024-07-18 04:05:48 发布

阅读量449

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/wangzuofei/p/6437896.html

版权

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();

转载于:https://www.cnblogs.com/wangzuofei/p/6437896.html