Error Code: 1193. Unknown system variable 'action'

Question

delimiter // drop trigger if exists tr_overdue //

create trigger tr_overdue -- type of trigger, etc
after update on invoice for each row begin if status = 'overdue' then insert into alerts values(new.message_date,new.origin,new.message); SET action = 'update', message_date = NOW(), origin=old.campaignno, message = 'invoice with number ' + old.invoiceno + ' is now overdue'; end if; end

Max · Accepted Answer · 2019-12-11 01:57:24Z

0

CREATE TRIGGER tr_overdue AFTER UPDATE ON Invoice FOR EACH ROW IF STATUS = 'overdue' THEN INSERT INTO alerts(columns1, column2,...) VALUES(new.message_date,new.origin,new.message);

I'm unsure if the columns you're updating in the SET statement also belong in Invoice, but if they do, then they should be included into the INSERT statement and that should fix the problem.

edited Dec 11, 2019 at 1:57

Max

8,6259 gold badges30 silver badges46 bronze badges

answered Dec 11, 2019 at 1:36

Jacob

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error Code: 1193. Unknown system variable 'action'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related