Re: Need help with my first trigger

[Devart Team]

You should use delimiters - whwich are statement separators used for source oblects.

DROP TRIGGER IF EXISTS berechne_gesamtsumme;

-- Set new delimiter $$
DELIMITER $$

CREATE TRIGGER  berechne_gesamtsumme
BEFORE UPDATE ON cat_spieler
FOR EACH ROW
BEGIN
  UPDATE cat_spieler SET gebuehr_basis = gebuehr_brunch;
END$$

DELIMITER ;

Note, that DELIMITER is not a MySQL command, it is a client command.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/