- delimiter $$
- CREATE PROCEDURE myProc()
- BEGIN
- DECLARE i int;
- SET i=1;
- loop1: WHILE i<=10 DO
- IF MOD(i,2)<>0 THEN /*Even number - try again*/
- SELECT CONCAT(i," is an odd number");
- END IF;
- SET i=i+1;
- END WHILE loop1;
- END$$
- mysql>
- mysql> delimiter ;
- mysql> call myProc();
- --该片段来自于http://www.codesnippet.cn/detail/090920135734.html
来源: http://www.codesnippet.cn/detail/090920135734.html