Problem creating SQLite trigger

Question

I have a table called posts having an INT field posted and a table domains having field posted too, this one is supposed to be the sum of a posteds of posts belonging to a certain domain. Whether the post belongs to a domain is determined by a foreign domain_id in the table posts which links to the id in domains. I'm trying to create a trigger that would update the posted of a domain every time the posted is changed for any of its posts. Here's what I was trying:

CREATE TRIGGER [update_posted]
AFTER UPDATE OF [posted]
ON posts
BEGIN
UPDATE domains SET posted = posted + NEW.posted - OLD.posted WHERE id = NEW.domain_id 
END

which complains about bad syntax near END. What's the problem?

Blorgbeard · Accepted Answer · 2010-06-23 10:32:50Z

2

Add a ; to the end of your update statement.

answered Jun 23, 2010 at 10:32

Blorgbeard

104k50 gold badges237 silver badges276 bronze badges

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

Collectives™ on Stack Overflow

Problem creating SQLite trigger

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