MySql Triggers

[moz_k2]

---

dili lage ni mugana ang nested if...

try changing else if to elseif

[xiao-xiao]

^ dili japon mugana

gi-inani na lng nako...

DELIMITER |

CREATE TRIGGER set_remarks
BEFORE UPDATE ON subjects_enrolled

FOR EACH ROW

BEGIN

IF NEW.grade <= 3.00 THEN
	SET NEW.remarks = 'Passed';
END IF;

IF NEW.grade = 'INC' THEN
	SET NEW.remarks = 'Incomplete';
END IF;

IF  NEW.grade = 5.00 THEN
	SET NEW.remarks = 'Failed';
END IF;

IF NEW.grade != 5.00 AND NEW.grade > 3.00 AND NEW.grade != 'INC' THEN
	SET NEW.grade = '---', NEW.remarks = 'No grade yet';
END IF;

END;
|