PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Fri Dec 15, 2017 12:58 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Thu Nov 16, 2017 4:31 am 
Offline
Forum Newbie

Joined: Thu Nov 16, 2017 4:10 am
Posts: 2
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


Top
 Profile  
 
PostPosted: Thu Nov 16, 2017 11:27 pm 
Offline
Forum Newbie

Joined: Sun Nov 15, 2015 12:57 pm
Posts: 12
Looks like you're missing semi-colons.


Top
 Profile  
 
PostPosted: Fri Nov 17, 2017 12:08 am 
Offline
Forum Newbie

Joined: Thu Nov 16, 2017 4:10 am
Posts: 2
Thank u very much .. can u plz tell me where am I missing semicolon


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Exabot [Bot] and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group