Trigger error INSERT Mysql

Question

I tried to create trigger AFTER UPDATE via phpmyadmin with body INSERT:

BEGIN
INSERT INTO updatespersonal SET (user, time, type, operator) VALUES (NEW.idDetailToUsers, CURRENT_TIMESTAMP(), "detailtousers", "update");
END

But I get error, reason that I can not understand:

1064 on line 2

May be problem in double quotes?

share the error message

Aman Aggarwal
– Aman Aggarwal

2015-07-10 12:04:08 +00:00
Commented Jul 10, 2015 at 12:04 — Aman Aggarwal
– Aman Aggarwal, Commented Jul 10, 2015 at 12:04

Aman Aggarwal · Accepted Answer · 2015-07-10 12:17:47Z

4

Error in Insert Statement, remove SET keyword:

INSERT INTO updatespersonal (user, time, type, operator) VALUES (NEW.idDetailToUsers, CURRENT_TIMESTAMP(), "detailtousers", "update");

edited Jul 10, 2015 at 12:17

answered Jul 10, 2015 at 12:03

Aman Aggarwal

18.6k10 gold badges55 silver badges84 bronze badges

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

Comments

Stanislovas Kalašnikovas · Accepted Answer · 2015-07-10 12:11:20Z

1

Your syntax is incorrect. You no need SET when using INSERT INTO.

Your code should be:

BEGIN
INSERT INTO updatespersonal (user, time, type, operator) VALUES (NEW.idDetailToUsers, CURRENT_TIMESTAMP(), "detailtousers", "update");
END

edited Jul 10, 2015 at 12:11

answered Jul 10, 2015 at 12:04

Stanislovas Kalašnikovas

9,0735 gold badges36 silver badges60 bronze badges

1 Comment

Stanislovas Kalašnikovas Over a year ago

Yea, you posted few seconds faster, because you posted only code with deleted word SET without description, while I wrote description why It not working and provided link to documentation.

Sachu · Accepted Answer · 2015-07-10 12:05:47Z

0

2 issues

In Insert INTO no need of SET
You are using a key word as column name user. enclose it in ""

BEGIN INSERT INTO updatespersonal ("user", time, type, operator) VALUES (NEW.idDetailToUsers, CURRENT_TIMESTAMP(), "detailtousers", "update"); END

answered Jul 10, 2015 at 12:05

Sachu

7,7549 gold badges59 silver badges101 bronze badges

Collectives™ on Stack Overflow

Trigger error INSERT Mysql

1064 on line 2

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1064 on line 2

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related