存储过程4:查询数据
来源:互联网 发布:安卓防蓝光软件哪个好 编辑:程序博客网 时间:2024/05/22 09:48
drop procedure if exists proc_name;delimiter //create procedure proc_name (in parameter integer)beginif parameter=0 thenselect * from student order by no asc;elseselect * 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 |+--------+----------+--------+