TRIGGER

[MudGuard]

Hi,

CREATE TRIGGER nach_trauerfall_neuz
AFTER INSERT
ON XXX...posts FOR EACH ROW
BEGIN
    IF NEW.post_name IS NOT NULL THEN
        INSERT INTO FM_Trauerfall (ID_Post, Name)
        VALUES(new.ID,NEW.post_name);
    END IF;
END

muß das NEW.ID heißen? Großgeschrieben?

cu,
Andreas a/k/a MudGuard