alter database Market COLLATE = utf8_general_ci;
1.创建一个可以统计表格内记录条数的存储函数 ,函数名为count_sch()
mysql>delimiter //
mysql>create function count_sch()
mysql>returns int
mysql> begin declare c int;
mysql>select count(1) into c from sch;
return c; end//
2、创建一个存储过程avg_sai,有3个参数,分别是deptno,job,接收平均工资,功能查询emp表dept为30,job为销售员的平均工资。
mysql>delimiter //
mysql>create procedure avg_sai(in p1 int,in p2 varchar(255),out p3 double)
mysql>begin
mysql>select avg(sai) into p3 from emp
mysql>where deptno=p1 and job=p2;
mysql>end/
数据库存储函数
最新推荐文章于 2024-10-06 21:49:48 发布