proble with the trigger in phpmyadmin
Posted: Thu Nov 16, 2017 3:31 am
IF NEW.avg > 15
THEN
SET NEW.grade='p'
ELSE
SET NEW.grade='F'
END IF ;
I am applying this trigger before insert in xampp .but i am getting an syntax error #1064 you have an error in sql syntax near ELSE SET NEW.grade='F'
END IF ;
please help me to resolve this error
THEN
SET NEW.grade='p'
ELSE
SET NEW.grade='F'
END IF ;
I am applying this trigger before insert in xampp .but i am getting an syntax error #1064 you have an error in sql syntax near ELSE SET NEW.grade='F'
END IF ;
please help me to resolve this error