trigger mysql to update items

trigger.sql

DELIMITER $$

CREATE TRIGGER on_items_update
    AFTER INSERT
    ON order_items FOR EACH ROW
BEGIN
   UPDATE orders SET total_photos=total_photos+1 WHERE id=new.order_id;
   END$$    

DELIMITER ;