PHP Developers Network
http://forums.devnetwork.net/

proble with the trigger in phpmyadmin
http://forums.devnetwork.net/viewtopic.php?f=2&t=144673
Page 1 of 1

Author:  maheshn [ Thu Nov 16, 2017 4:31 am ]
Post subject:  proble with the trigger in phpmyadmin

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

Author:  benanamen [ Thu Nov 16, 2017 11:27 pm ]
Post subject:  Re: proble with the trigger in phpmyadmin

Looks like you're missing semi-colons.

Author:  maheshn [ Fri Nov 17, 2017 12:08 am ]
Post subject:  Re: problem with the trigger in phpmyadmin

Thank u very much .. can u plz tell me where am I missing semicolon

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/