MySQL-Trigger Creation -


am trying create 1 update trigger.here code..

delimiter $$ create trigger before_user_update   before update on user     each row  begin insert user_index     set action = 'update',     firstname = old.firstname,     email = old.email,     changedat = now() end  $$ delimiter ; 

for code got error this..

error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'end' @ line 10

how can solve this.. please me..


Comments