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
Post a Comment