Mysql Trigger范例

例子1:
create trigger bi_emps_fer before insert on emps for each row
begin

    declare newsal numeric default 0;
    declare namelength, l_loop int default 0;

    set namelength = length(new.emp_name);

    while l_loop < namelength do

       set newsal := newsal   new.salary;

       set l_loop := l_loop   1;

    end while;

    set new.salary = newsal;

end


例子2:
create trigger bi_emp_fer before insert on emps for each row
begin
   declare l_dept_name varchar(30);
 
   select description into l_dept_name from dept where dept_id = new.dept_id;
   set new.dept_name = l_dept_name;
end;//