Posted: Mon Feb 11, 2008 2:10 am Post subject: trigger help in mysql
is this how you write the update trigger so the table automatically updates
Code:
create trigger updater
begin
update items,sales
set items.number_on_hand = items.number_on_hand - sales.number_sold
where Item_id = sales.Sales_id;
end
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum