More than one if clause for MySQL Trigger

Question

I want to reach something like that:

When a data inserted it will check a date column, compare it with current date and it will write something to another column. Example:

Today 27/08/2018
Date 27/08/2018
Result: Same Day

Today 27/08/2018
Date 26/08/2018
Result: Before Today

Today 27/08/2018
Date 28/08/2018
Result: After Today

I have tried this and does not work:

//CREATE TRIGGER trigger_update_status_before_insert 
BEFORE INSERT 
ON tablex
FOR EACH ROW BEGIN
  IF (NEW.date < CURDATE()) THEN
        SET NEW.status = 'Before Today'
  END IF

  IF (NEW.date = CURDATE()) THEN
        SET NEW.status = 'Same Day'
  END IF

  IF (NEW.date > CURDATE()) THEN
        SET NEW.status = 'After Today'
  END IF
END;//

phpmyadmin delimiter: //

Every statement must be terminated.

P.Salmon
– P.Salmon

2018-08-27 18:06:44 +00:00
Commented Aug 27, 2018 at 18:06 — P.Salmon
– P.Salmon, Commented Aug 27, 2018 at 18:06

xuleh · Accepted Answer · 2018-08-27 18:33:11Z

0

error in your SQL syntax creating MySQL trigger @p.campbell 's answer solved the problem. I just deleted semi column and it worked.

answered Aug 27, 2018 at 18:33

xuleh

11 bronze badge

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

Collectives™ on Stack Overflow

More than one if clause for MySQL Trigger

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related