What's wrong with my trigger? I'm getting this error:
1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' whats causing this error what wrong ma i doing?? this my trigger below
When I try to create this trigger:
CREATE TRIGGER emplog_update AFTER UPDATE ON gos
FOR EACH ROW
INSERT INTO emp (id, last_name, first_name,action, time_taken, description)
select NEW.id,NEW.last_name,NEW.first_name,'U',NOW(),USER(),
concat_ws(',',
(case when new.id <> old.id then 'id' end),
(case when new.last_name <> old.last_name then 'last_name' end),
(case when new.first_name <> old.first_name then 'first_name' end)
); );
How can I resolve this issue?
AFTER UPDATE
trigger for this table. – ypercube Apr 25 at 6:08work
.gos
SETfirst_name
= 'maxnn' WHEREgos
.id
=6 MySQL said: #1136 - Column count doesn't match value count at row 1 – bli Apr 25 at 6:17select
but 6 in theINSERT INTO emp (id, last_name, first_name,action, time_taken, description)
. User column is missing there. – ypercube Apr 25 at 6:19