CREATE PROCEDURE pro1()

       BEGIN

         DECLARE i int;

         DECLARE dbName VARCHAR(40);

         SET i = 0;

         while i<5 do

           SET dbName = concat('table_',i);

           set @sqlStr=CONCAT('insert into temp_table SELECT a,b from ',dbName,' WHERE c in ("")');

            PREPARE stmt from @sqlStr;

            EXECUTE stmt;

           set i=i+1;

         end while;

       END;

CALL pro1();

DROP PROCEDURE pro1;