MySQL procedure to create a table each time another procedure is called (merging two scripts)

The attached code is a MySQL procedure.  It fills the row of one table (node_) with rows of another table (master_) based on a series of conditions. Here is the creation script for node_ table:

SELECT @tblname:=concat('node_',date_format(now(),'%Y%m%d%H%i%S'),'');
SELECT @cr := concat('CREATE TABLE ',@tblname,' (
  `node_id`  INT(5),
  `node_code`  VARCHAR(4),
  `node_1st`  VARCHAR(1),
  `node_2nd`  VARCHAR(1),
  `node_3rd`  VARCHAR(2),
  `node_act`  VARCHAR(1),
  `node_ref`  INT(4),
  `node_dur`  INT(4),
  `node_suc`  INT(4),
  `node_log`  VARCHAR(2),
  `node_lag`  INT(4),
  `node_con`  INT(4))','');
PREPARE stmt from @cr;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Now what i need to know how to do is how to have the attached code incorporate the above creation scipt, in such that each time the attached code is called, a new table is created.

So how do I do that?

create procedure WALKTHROUGH() 
 
BEGIN 
 
DECLARE rowwalker CURSOR as select * from "master_" order by primary_key ASC; 
 
OPEN rowwalker; 


read_loop:  LOOP 

WHILE   rowwalker.PRE iS not null DO 
        fetch rowwalker; 
	IF done THEN 
   		LEAVE read_loop; 
	END IF; 
end while; 


INSERT INTO NODE_ (node_act, node_ref, node_suc, node_log, node_lag, node_con) 

           VALUES ('1', rowwalker.REF, rowwalker.SUC, rowwalker.LOG, rowwalker.LAG, rowwalker.CON); 


INSERT INTO NODE_ (node_act, node_ref, node_suc, node_log, node_lag, node_con) 
           VALUES (SELECT '1', REF, SUC, LOG, LAG, CON FROM master_ WHERE SUC = rowwalker.SUC);


IF done THEN 
   LEAVE read_loop; 
END IF; 

END LOOP; 
 
 
CLOSE rowwalker; 
 
END;

Select allOpen in new window