( sibidiba | 2008. 04. 27., v – 18:33 )

Rakd begin end közé, és használj mási kdelimiter ehhez, valahogy így:

mysql> deli miter //
mysql> CRE ATE TRIGGER mac_trigger AFTER INSERT ON radacct FOR EACH ROW
- > BE GIN
- > IF (SEL ECT 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;
mysql> //
mysql> deli miter ;

--
The Net is indeed vast and infinite...
http://gablog.eu