存储过程4:查询数据

种子之家

于 2012-08-19 18:16:20 发布

阅读量469

点赞数

分类专栏： MySql 文章标签：存储 integer

本文链接：https://blog.csdn.net/seeds_home/article/details/7883739

版权

MySql 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

drop procedure if exists proc_name;

delimiter //

create procedure proc_name (in parameter integer)
begin
	if parameter=0 then
	select * from student order by no asc;
	else
	select * from student order by height asc;
	end if;
end;
//

delimiter ;

call proc_name(0);
+--------+----------+--------+
| no     | name     | height |
+--------+----------+--------+
| 122654 | wangwu   |   1.36 |
| 123654 | zhangsan |   1.56 |
| 129854 | lisi     |   1.16 |
+--------+----------+--------+

call proc_name(5);
+--------+----------+--------+
| no     | name     | height |
+--------+----------+--------+
| 129854 | lisi     |   1.16 |
| 122654 | wangwu   |   1.36 |
| 123654 | zhangsan |   1.56 |
+--------+----------+--------+