使用 SELECT/JOIN 触发插入 [英] Trigger Insert with a SELECT/JOIN

问题描述

我在SELECT AND JOIN中写了一个触发器INSERT AFTER:.

I wrote a trigger INSERT AFTER: with I inside SELECT AND JOIN.

DROP TRIGGER IF EXISTS `InsertArticle`;
DELIMITER //
CREATE TRIGGER `InsertArticle` AFTER INSERT ON `article`

FOR EACH ROW 
  insert into log (LogTime, LogIdNote, LogName, LogType, LogIdUser, logTypeCategory, LogTypeUser, LogUrl) 
    select NEW.ArticleTime, NEW.idArticle, NEW.ArticleName, 1, NEW.ArticleToUserID, NEW.ArticleCategory, u.UsersTypeAccount, ct.URLCategorysubscribetotype
    from users u where u.idUsers = NEW.ArticleToUserID LEFT JOIN categorysubscribetotype ct ON ct.CategoryTypeCategorysubscribetotype = 1;
END
//
DELIMITER ;

当我尝试创建触发器时，出现错误 1422.可能是我的触发器语法错误?

When I tried to create trigger, I get error 1422. May be I have a wrong trigger sintax?

推荐答案

试试这个:

DROP TRIGGER IF EXISTS `InsertArticle`;
DELIMITER //
CREATE TRIGGER `InsertArticle` AFTER INSERT ON `article`

FOR EACH ROW 
  insert into log (LogTime, LogIdNote, LogName, LogType, LogIdUser, logTypeCategory, LogTypeUser, LogUrl) 
    select NEW.ArticleTime, NEW.idArticle, NEW.ArticleName, 1 as LogType, NEW.ArticleToUserID, NEW.ArticleCategory, u.UsersTypeAccount, ct.URLCategorysubscribetotype
    from users u  LEFT JOIN categorysubscribetotype ct ON ct.CategoryTypeCategorysubscribetotype = 1 where u.idUsers = NEW.ArticleToUserID;
END
//
DELIMITER ;

这篇关于使用 SELECT/JOIN 触发插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！