我在mysql触发器里添加if判断，报错，哪位大神帮我看看是哪错了

Question

CREATE TRIGGER tr_seach_insert AFTER INSERT ON rnews FOR EACH ROW
BEGIN
 if not exists (select r.rid from rnewscode r join files f where r.rid=f.rid and r.id = new.id) then
    INSERT INTO search_tcf2 (rid,`titles`, appdate,`cname`,`contens`,enable,`mname`)
VALUES
    (NEW.rid, NEW.titles, NEW.appdate, NEW.cname,NEW.contens,NEW.enable,NEW.mname);
END if;

Answer 1

请问解决了么