mysql> create table emp(
-> id int primary key auto_increment,
-> name varchar(50) not null,
-> glass varchar(50) not null);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into sch values (1,'xiaommg','glass 1'),(2,'xiaojun','glass 2');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from sch;
+----+---------+---------+
| id | name | glass |
+----+---------+---------+
| 1 | xiaommg | glass 1 |
| 2 | xiaojun | glass 2 |
+----+---------+---------+
2 rows in set (0.00 sec)
mysql> \d $$
mysql> create function count_sch()
-> returns int
-> begin
-> declare a int default 0;
-> select count(*) into a from sch;
-> return a;
-> end $$
Query OK, 0 rows affected (0.00 sec)
mysql> \d
mysql> select count_sch();
+-------------+
| count_sch() |
+-------------+
| 2 |
+-------------+
1 row in set (0.00 sec)
二、原表在第四天
mysql> \d $$
mysql> create procedure avg_sai(in p1 int,in p2 varchar(50),out p3 int)
-> begin
-> select avg(sai) into p3 from emp
-> where deptno=p1 and job=p2;
-> end $$
Query OK, 0 rows affected (0.00 sec)
mysql> \d