MySQL trigger: ERROR 1064 (42000): You have an error in your SQL syntax

Question

I'm trying to create a trigger that monitor changes on a table and then insert those change to another table as follows

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 keeps showing the following error

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

the following statement works very file with a where clause criteria

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

what's wrong with the insertion statement within the trigger

are you using a version higher than 5.0.10 ?

Zed
– Zed

2009-08-18 13:56:24 +00:00
Commented Aug 18, 2009 at 13:56 — Zed
– Zed, Commented Aug 18, 2009 at 13:56

bluish · Accepted Answer · 2011-12-01 09:23:44Z

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;

edited Dec 1, 2011 at 9:23

bluish

27.5k28 gold badges126 silver badges185 bronze badges

answered Aug 18, 2009 at 13:58

IgorS

1631 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL trigger: ERROR 1064 (42000): You have an error in your SQL syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related