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
    ->