qq_27127363的博客

create procedure repeat_text()begin set @i=5; ins:repeat set @i=@i-1; select @i; until @i=0 end repeat;end;call repeat_text();drop procedure repeat_text;

create procedure loop_leave_iterate_test()begin set @i=0; set @j=0; ins:loop if @i<5 then set @j=@j+1; if@j=5 then iterate ins;#跳过本轮循环 end if; set .

create procedure case_test()begin declare i int default 0; case i when 0 then select 0; when 1 then select 1; end case;end;call case_test();drop procedure case_test;

create procedure if_test()begin declare i int default 0; if i>3 then select '大于3'; elseif i=3 then select '等于3'; elseif i=0 then select '等于0'; end if;end;call if_test();drop pr.

create procedure add_data()begin declare i int default 0; while i<100 do set i=i+1; insert into add_test(id, name) value (i,'test_data'); end while;end;call add_data();drop procedure add_data();