mysql第五次作业

先在图形界面创建好表格，输入数据

DELIMITER $$

CREATE
    FUNCTION `hanshu`.`count_scu()`()
    RETURNS INT
    BEGIN
	DECLARE c INT;
	SELECT COUNT(*) INTO c FROM TEXT;
	RETURN c;
    END$$

DELIMITER ;

2、查询语句

SELECT count_scu();

第二小题

1、

DELIMITER $$

CREATE
    PROCEDURE `hanshu`.`p1`(IN dept INT(2),IN jobs VARCHAR(255),OUT avg_my DOUBLE)
    BEGIN
	SELECT AVG(sai) INTO avg_my FROM emp
	WHERE deptno=dept AND job=jobs;
    END$$

DELIMITER ;

2、查询

mysql> call p1(30,'销售员',@a);
Query OK, 1 row affected (0.00 sec)

mysql> select @a;
+-------+
| @a    |
+-------+
| 14000 |
+-------+
1 row in set (0.00 sec)