mysql存储过程模板

mysql存储过程模板

  drop PROCEDURE  if exists pro_name;  

CREATE PROCEDURE pro_name()  

begin

    declare aaa,k,i int;

    declare bbb date;   

    declare myprice decimal(16,2);

    declare ccc varchar(500);  

    DECLARE done INT DEFAULT FALSE;

    DECLARE cur_1 CURSOR FOR select aaa from tablename;

    

    

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

   

 

    OPEN cur_1; 

    

    read_loop: LOOP

        FETCH cur_1 INTO aaa, bbb, ccc; 

 

        IF done THEN

           LEAVE read_loop;

        END IF;

 

 set i=0;

          while i<=aaa do

insert into tablename1(id,aa) 

   select REPLACE(UUID(), '-', ''),DATE_FORMAT(DATE_ADD(my_time,  INTERVAL  i*10   MINUTE ),'%Y%m%d%H%i%s')

      from mytable ;

              set i=i+1;

          end while;

commit;

 SET done = FALSE;

    END LOOP;

    close cur_1; 

end