Simple Trigger

DELIMITER //
CREATE TRIGGER testing_before BEFORE INSERT ON campusday FOR EACH ROW
BEGIN
IF (SELECT NEW.Period) > 8 || (SELECT NEW.Period) < 1
    THEN SIGNAL SQLSTATE '45000'
    SET MESSAGE_TEXT='Not a valid period.';
END IF;
END //
DELIMITER ;