mercredi 3 juin 2020

MySQL Trigger with Multiple IF Statements

I am new to this and cant seem to find a situation similar to mine and Im sure the answer is simple.

I have two columns, one is a predefined licenseplate ("licenseplate") and one that will be a user inputted licenseplate ("enterlicenseplate").

I made a third column which will be the sort of error check column and will have its values inputted by a trigger. Basically if the entered license plate is the same as the predefined licenseplate, set that third column to 0, if the entered license plate is null(not inputted anything yet( set that to 1, and if theres values in both and they dont match, set it 2. But i keep getting script errors. Not sure if its my syntax or im going about this all wrong.

I appreciate any help!

 CREATE TRIGGER MatchPlateOnUPDATE 
 BEFORE UPDATE ON wp_wpdatable_3
 FOR EACH ROW 
 BEGIN
 IF (NEW.enterlicenseplate is NULL) THEN
 UPDATE wp_wpdatatable_3
    SET MatchingPlates = 0;

  ELSEIF (NEW.enterlicensplate = New.licenseplate) THEN
 UPDATE wp_Wpdatatable_3
    SET MatchingPlates = 1;
ELSE UPDATE wp_Wpdatatable_3
SET MatchingPlates = 2;
END

Aucun commentaire:

Enregistrer un commentaire