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 Aug 27 '18 at 18:06 — P.Salmon, Aug 27 '18 at 18:06

score 0 · Answer 1 · answered Aug 27 '18 at 18:33

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 '18 at 18:33

xuleh

1
1

More than one if clause for MySQL Trigger

1 Answers1