create table dep(id int primary key);// create table emp(id int primary key, salary int, d int, constraint fk_e_d foreign key (d) references dep(id) on delete cascade on update cascade);// insert into dep values (1),(2),(3);// insert into emp values(1,10000,1),(2,20000,2),(3,30000,3);// create procedure showsalary(in myid int) begin select salary from emp where id=myid; select salary from emp where id=myid+1; end;// create function showsalary2(myid int) returns int begin select salary from emp where id=myid; select salary from emp where id=myid+1; return 7; end;// create procedure handlerdemo() begin set @aux=0; begin declare d int; declare c cursor for select salary from emp where salary<0; declare exit handler for sqlstate '02000' begin end; open c; fetch c into d; end; set @aux=1; end;// create procedure demoleave() a:begin set @aa=0; b:begin leave a; end b; set @aa=1; end a;// create trigger countemp before insert on emp for each row select count(*) into @n_emp from emp;// create trigger countemp2 after insert on emp for each row select count(*) into @n_emp from emp;// create trigger countemp3 after delete on emp for each row select count(*) into @n_emp from emp;// create trigger newemp before insert on emp for each row begin declare m int; select count(*) into m from emp where id=new.id; if m>0 then begin select max(id)+1 into m from emp; set new.id=m; end; end if; end;// create trigger nogood after update on emp for each row select 777 into @aaa;// update dep set id=4 where id=3;// create procedure myavg(in dep int, out a float) #create function myavg(in dep int) returns float begin declare n int; declare s int; declare done int default 0; declare continue handler for SQLSTATE '02000' set done=1; declare c cursor for select salary from emp where d=dep; set a=0; set n=0; open c; while not done do fetch c into s; if not done then set a=a+s; set n=n+1; end if; end while; close c; set a=a/n; #return a; end; create trigger myavg2 before insert on emp for each row begin call myavg(new.dep,@aux); end; select @aux//