MYSQL第五次作业

create trigger orders_insert_trigger
    -> after insert on orders for each row
    ->  update goods set num = num - new.onum
    -> where gid = new.gid;

create trigger orders_insert_trigger2
    -> after delete on orders for each row
    -> update goods set num = num + old.onum
    -> where  gid = old.gid;

create trigger orders_insert_trigger3
    -> after update on orders for each row
    -> update goods set num = num+old.onum-new.onum
    -> where goods.gid = new.gid;

mysql> create procedure s1 ()
    -> begin
    ->      select name , incoming from emp_new;
    -> end //

mysql> create procedure s2 (in name1 varchar(10))
    -> begin
    ->     select name,age from emp_new where name=name1;
    -> end //
Query OK, 0 rows affected (0.00 sec)

create procedure s3 (in dept_num int , out avg_incoming float)
    -> begin
    ->     select avg(incoming)  into avg_incoming from emp_new where dept2=dept_num group by dept2;
    -> end //