存储过程动态获取表名，然后以表名做参数

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