mysql的循环判断语句_mysql实例 循环结构中使用if语句

本代码在mysql的循环结构中应用if语句，供大家参考。

代码：

mysql> delimiter $$

mysql> CREATE PROCEDURE myProc()

-> BEGIN

->

-> DECLARE i int;

-> SET i=0;

-> loop1: REPEAT

-> SET i=i+1;

-> IF MOD(i,2)<>0 THEN /*Even number - try again*/

-> SELECT CONCAT(i," is an odd number");

-> END IF;

-> UNTIL i >= 10

-> END REPEAT;

-> END$$

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

mysql> call myProc();

+-------------------------------+

| CONCAT(i," is an odd number") |

+-------------------------------+

| 1 is an odd number |

+-------------------------------+

1 row in set (0.00 sec)

+-------------------------------+

| CONCAT(i," is an odd number") |

+-------------------------------+

| 3 is an odd number |

+-------------------------------+

1 row in set (0.33 sec)

+-------------------------------+

| CONCAT(i," is an odd number") |

+-------------------------------+

| 5 is an odd number |

+-------------------------------+

1 row in set (0.33 sec)

+-------------------------------+

| CONCAT(i," is an odd number") |

+-------------------------------+

| 7 is an odd number |

+-------------------------------+

1 row in set (0.34 sec)

+-------------------------------+

| CONCAT(i," is an odd number") |

+-------------------------------+

| 9 is an odd number |

+-------------------------------+

1 row in set (0.34 sec)

Query OK, 0 rows affected (0.34 sec)

mysql> drop procedure myProc;

Query OK, 0 rows affected (0.00 sec)