How to write a trigger in MySql

See more:

MySQL

Hi all.

i need write a Update trigger when the table's perticular column updated..

i tried the following query.

create Trigger Trigger1 after Update of EMPID on  EMPmaster for  each row
begin
insert into EMPMaster_Backup (OLDEMPID) values (EMPID );
end;

But it showing error .

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'of EMPID on  EMPmaster for  each row
begin
insert into EMPMaster_Backup ' at line 1