I can't seem to figure out what to do to get this trigger to work. I'm running MySQL 5.0.15. Anyone have any idea what I'm doing wrong?


drop trigger t_insert_customer_reviews;
delimiter //
create trigger
t_insert_customer_reviews
after insert on
customer_reviews
for each row
declare score double(4,1);
declare num_reviews int;

select avg(rating)*2 into score from customer_reviews where asin = new.ASIN;
select count(customer_id) into num_reviews from customer_reviews where asin = new.ASIN;

update
v_products
set
rating = score,
reviews = num_reviews
where
asin = NEW.asin;
//



Thanks,

Kurt