A little help with my trigger syntax

[Kurt Schell]

I can't seem to get this trigger to work.. I'm not sure what I'm doing wrong but I think my syntax is probably the problem.


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;
//


Any ideas?

Thanks,

Kurt