the same code works under Mysql Workbench or php call, but
not under HeidiSQl
USE sauna;
DROP TRIGGER IF EXISTS deleteword;
DELIMITER |
CREATE TRIGGER deleteword AFTER DELETE ON kirja
FOR EACH ROW
BEGIN
SET @maxid = (SELECT max(id) FROM kirja LIMIT 1);
IF @maxid>OLD.id THEN
UPDATE kirja SET id = OLD.id where id=@maxid;
END IF;
END;|
DELIMITER ;