MySQL如何建立存储过程

[ccdjk]

不知道在MySQL建立存储过程的语法是怎么样的
比如有student表
----id----name----role----sex----age
---001-----zhu---guest----boy-----20
---002------li---guest----boy-----23
---003----zhao---admin---girl-----24

如何建个存储过程
(我采用InterBase数据库的形式描述)
存储过程主体为select max(age) from student where role = :输入参数 into :输出参数

谢谢大家了

[ccdjk]

顶顶

[hy2003fly]

mysql> create table student(id int not null auto_increment primary key,
-> name varchar(20),role varchar(20),sex varchar(4), age int );
Query OK, 0 rows affected (0.05 sec)

mysql> insert into student values(1,'zhu','guest','boy',20),(2,'li','guest','boy
',23),(3,'zhao','admin','girl',24);
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from student;
+----+------+-------+------+------+
| id | name | role | sex | age |
+----+------+-------+------+------+
| 1 | zhu | guest | boy | 20 |
| 2 | li | guest | boy | 23 |
| 3 | zhao | admin | girl | 24 |
+----+------+-------+------+------+
3 rows in set (0.00 sec)

mysql> delimiter //

mysql> create procedure tt(in myrole varchar(10),out a int)
-> begin
-> select max(age) from student where role=myrole;
-> end
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> call tt('guest',@a)//
+----------+
| max(age) |
+----------+
| 23 |
+----------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)