Cannot create trigger - bad syntax

Question

I want to make trigger which update total_money after every insert in transactions table. I cannot create it because of error: #

1064 - Something is wrong in your syntax near '' in line 3

Here is my trigger creation code:

CREATE TRIGGER transactions_insert AFTER INSERT ON transactions 
    FOR EACH ROW BEGIN
      UPDATE users SET users.total_money = users.total_money + NEW.Price WHERE users.User_ID = NEW.User_id;
    END;

Hariraman Radhakrishnan · Accepted Answer · 2018-05-15 17:51:40Z

1

If you add delimiters it will work, as given below

delimiter //
CREATE TRIGGER transactions_insert AFTER INSERT ON transactions FOR EACH ROW BEGIN UPDATE users SET users.total_money = users.total_money + NEW.Price WHERE users.User_ID = NEW.User_id; END;
//

answered May 15, 2018 at 17:51

Hariraman Radhakrishnan

1901 gold badge1 silver badge12 bronze badges

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

Collectives™ on Stack Overflow

Cannot create trigger - bad 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