mysql> deli miter //
mysql> CRE ATE TRIGGER mac_trigger AFTER INSERT ON radacct FOR EACH ROW
-> BEGIN
-> IF (SE LECT COUNT(*) FROM radcheck WHERE ( UserName = NEW.UserName AND Attribute = 'Calling-Station-Id' AND Value = '')) > 0 THEN
-> UPD ATE radcheck SET Value = `NEW.Calling-Station-Id` WHERE (UserName = NEW.UserName AND Attribute = 'Calling-Station-Id')
-> END IF;
-> END;
-> //
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE radcheck SET Value = `NEW.Calling-Station-Id` WHERE (UserName = NEW.UserN' at line 4