create trigger bi_emps_fer before insert on emps for each row
begin 
   
   declare namelength numeric;
   
   set namelength = length(new.emp_name);
   
   set new.salary = new.salary * namelength;

end