CREATE DEFINER=`coolcloudstat`@`%` PROCEDURE `selectPkg`()
BEGIN
DECLARE tableName VARCHAR(100);
DECLARE table_name_done INT DEFAULT 0;
DECLARE table_name_cursor CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_name LIKE '%tb_yl_model_app_usage_info_coolpad%' AND table_schema='statanalyse';
DECLARE CONTINUE HANDLER FOR NOT FOUND SET table_name_done=1;
OPEN table_name_cursor;
WHILE table_name_done <> 1 DO
FETCH table_name_cursor INTO tableName;
SELECT tableName;
/*针对每个表名进行处理,即查询包名并输入到另外一个表里面去*/
SET @sqlStr = CONCAT('INSERT IGNORE INTO tb_yl_pkgs(pkg_name) SELECT distinct pkg_name FROM `',tableName,'`');
PREPARE insert_stat FROM @sqlStr;
EXECUTE insert_stat ;
DEALLOCATE PREPARE insert_stat;
END WHILE;
CLOSE table_name_cursor;
END
BEGIN
DECLARE tableName VARCHAR(100);
DECLARE table_name_done INT DEFAULT 0;
DECLARE table_name_cursor CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_name LIKE '%tb_yl_model_app_usage_info_coolpad%' AND table_schema='statanalyse';
DECLARE CONTINUE HANDLER FOR NOT FOUND SET table_name_done=1;
OPEN table_name_cursor;
WHILE table_name_done <> 1 DO
FETCH table_name_cursor INTO tableName;
SELECT tableName;
/*针对每个表名进行处理,即查询包名并输入到另外一个表里面去*/
SET @sqlStr = CONCAT('INSERT IGNORE INTO tb_yl_pkgs(pkg_name) SELECT distinct pkg_name FROM `',tableName,'`');
PREPARE insert_stat FROM @sqlStr;
EXECUTE insert_stat ;
DEALLOCATE PREPARE insert_stat;
END WHILE;
CLOSE table_name_cursor;
END