这只是一个简短的问题,毫无疑问,外面的人会知道答案的.
我需要能够在一个触发器内进行多次插入/更新.每一次try 都以失败告终:(
DROP TRIGGER IF EXISTS `Insert_Article`//
CREATE TRIGGER `Insert_Article` AFTER INSERT ON `Article`
FOR EACH ROW insert into FullTextStore (`Table`, `PrimaryKey`, `ColumnName`, `Data`, `Created`) values ('Article', NEW.ArticleID, 'Description', NEW.Description, UNIX_TIMESTAMP())
//
目前,上面的代码只是在插入父表时将一行插入到表中.这个不错.
为了让它适用于多种价值观,我需要做
DROP TRIGGER IF EXISTS `Insert_Article`//
CREATE TRIGGER `Insert_Article` AFTER INSERT ON `Article`
FOR EACH ROW insert into FullTextStore (`Table`, `PrimaryKey`, `ColumnName`, `Data`, `Created`)
select 'Article', NEW.ArticleID, 'Description', NEW.Description, UNIX_TIMESTAMP()
union
select 'Article', NEW.ArticleID, 'Keywords', NEW.Keywords, UNIX_TIMESTAMP()
//
但是一定有更简单的方法吗?当我try 使用;要终止每一条语句,它会以
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL version for the right syntax to use near 'select 'Article', NEW.ArticleID, 'Keywords', 'NEW.Keywords, UNIX_TIMESTAMP())' at line 1
我甚至不能让多个UPDATE语句工作.
如果有人能指出我做错了什么,那将是一个很大的帮助?
干杯
加文