MySQL触发器: ERROR 1064 (42000): You have an error in your SQL syntax

Question

我正在尝试创建一个触发器来监视表上的更改，然后将这些更改插入到另一个表中，如下所示

CREATE TRIGGER userChangePasswd
BEFORE UPDATE ON originalTable
FOR EACH ROW
BEGIN
INSERT INTO logs (email,clear,name ) SELECT email,clear,name FROM  originalTable
END

mysql一直显示以下错误

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO logs (email,clear,name ) SELECT email,clear,name FROM ' originalTable at line 5

以下语句适用于具有 where 子句条件的文件

INSERT INTO logs (email,clear,name ) SELECT email,clear,name FROM  originalTable 

触发器内的插入语句有什么问题

Answer 1

CREATE TRIGGER `orgTbl_before_upd_tr` BEFORE UPDATE ON `orgTbl`
FOR EACH ROW
BEGIN
  INSERT INTO newTbl (field1, field2) VALUES (old.field1, old.field2);
END;