Help with trigger

Discussion in 'MySQL' started by tanyania, Jul 7, 2011.

0
  1. #1
    I have 2 tables, when the table that q1 is updated the trigger is fired and should take the value of q1 and add to Consumables.Quantity.

    UPDATE U SET Quantity = U.Quantity + Inserted.q1 FROM Consumables as U INNER JOIN Inserted ON U.Product = Inserted.Product

    This I'm sure used to work, but no longer

    Any ideas?
     
    tanyania, Jul 7, 2011 IP