Re: Need help creating a trigger

[Vikram Shityalkar]

try this,

create trigger recalc_post_count after insert on posting
decalre ver INT
select count(*) INTO ver from posting where thread_id = new.thread_id;
update thread set post_count = ver where thread_id = new.thread_id;