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

Popular posts from this blog

ruby on rails - Permission denied @ sys_fail2 - (D:/RoR/projects/grp/public/uploads/ -

c++ - nodejs socket.io closes connection before upgrading to websocket -

java - What is the equivalent of @Value in CDI world? -