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