#显示储存过程

show procedure status;

#设置结束符

delimiter $;

#创建储存过程

create procedure procedure_name()

  begin

  --sql语句

  end$

create procedure myshow()

  begin

    select user(),database();

  end$

  #调用储存过程

  call procedure()

  call procedure

  #没有对数时括号可省

mysql> use test$

Database changed

mysql> create procedure myshow()

    ->   begin

    ->     select user(),database();

    ->   end$

Query OK, 0 rows affected (0.03 sec)

mysql> call myshow

    -> $

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

| user()         | database() |

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

| root@localhost | test       |

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

1 row in set (0.02 sec)

Query OK, 0 rows affected (0.03 sec)

mysql> myshow()$

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your

MySQL server version for the right syntax to use near 'myshow()' at line 1

mysql> call myshow()$

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

| user()         | database() |

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

| root@localhost | test       |

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

1 row in set (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql>