Here is my SQL, but the MySQL sever always said that it have an error in SQL syntax. I have tried many times but it dosen't work. Please Help!
DELIMITER //
CREATE TRIGGER Score_Count_for_Contestant
AFTER INSERT ON award
FOR EACH ROW
BEGIN
IF NEW.award = 'gold'AND contestant.CID=new.CID THEN
UPDATE contestant SET contestant.score= contestant.score+10
IF new.Award='silver' AND contestant.CID=new.CID THEN
UPDATE contestant SET contestant.score= contestant.score+8
IF new.Award='bronze' AND contestant.CID=new.CID THEN
UPDATE contestant SET contestant.score= contestant.score+6
END IF
END //
DELIMITER ;
Aucun commentaire:
Enregistrer un commentaire