Error in mysql Trigger -
i trying create trigger. first of created table employees , table employees_audit:
create table employees ( employeenumber int(11) not null, lastname varchar(50) not null, firstname varchar(50) not null, extension varchar(10) not null, email varchar(100) not null, officecode varchar(10) not null, reportsto int(11) default null, jobtitle varchar(50) not null, primary key (employeenumber) ) create table employees_audit ( id int(11) not null auto_increment, employeenumber int(11) not null, lastname varchar(50) not null, changedon datetime default null, action varchar(50) default null, primary key (id) )
then created trigger:
delimiter $$ create trigger before_employee_update before update on employees each row begin insert employees_audit set action = 'update', employeenumber = old.employeenumber, lastname = old.lastname, changedon = now(); end$$ delimiter ;
both first table , second created when execute trigger error
#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'delimiter $$ create trigger before_employee_update before update on employe' @ line 1
is there error in code or need mysql version?
are running phpmyadmin? if delimiter should set in field below sql textarea not in text area itself.
and no. contrary answer has been deleted, there no ;
needed after delimiter $$
because set delimiter $$;
Comments
Post a Comment