mysql存储过程

 

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.13 sec)

mysql> use test;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> delimiter $$
mysql> create procedure my_proc1(name varchar(50),out resultName varchar(50))
    ->  begin
    ->          set resultName=name;
    ->  end $$
Query OK, 0 rows affected (0.13 sec)

mysql> create procedure my_proc_if_else(count int,out result varchar(50))
    ->  begin
    ->          if (count=0) then
    ->                  set result="the count is zero";
    ->          elseif (count =1) then
    ->                  set result="the count is one";
    ->          else
    ->                  set result="the count is the other number";
    ->          end if;
    -> end $$
Query OK, 0 rows affected (0.04 sec)

mysql> create procedure my_proc_loop(countBegin int,out countEnd int)
    ->  begin
    ->          declare countTemp int default 0;
    ->          my_loop:loop
    ->                  set countBegin=countBegin+countTemp;
    ->                  set countTemp=countTemp+2;
    ->                  if (countTemp>10) then
    ->                          leave my_loop;
    ->                  end if;
    ->          end loop my_loop;
    ->          set countEnd=countBegin;
    ->  end $$
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure my_proc_while(countBegin int,out countEnd int)
    ->  begin
    ->          while (countBegin<=10) do
    ->                  set countBegin=countBegin+1;
    ->          end while;
    ->          set countEnd=countBegin;
    -> end $$
Query OK, 0 rows affected (0.00 sec)

mysql>