Create Triggers - Error in DECLARE

Question

I recognize triggers from http://forge.mysql.com/wiki/Triggers and I have:

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 

and error:

1064 - You have an error in the SQL syntax; check the manual that matches your MySQL server version for the correct syntax to use about '' on line 4

why? I am using MySQL 5.5.8 and phpmyadmin 3.3.9

Answer 1

Did you specify the delimiters?

 delimiter # create trigger bi_emps_fer before insert on emps for each row begin declare newsal decimal(10,2) default 0; // do sql stuff here but not what you're doing ! set new.salary = newsal; end# delimiter ;