trigger help in mysql

WeberForums.com Forum Index -> MySQL General

View previous topic :: View next topic   Author Message bmn Joined: 18 Feb 2006 Posts: 15 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 note: there are 2 tables Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

WeberTrivia Questions   Think you are smart? Prove it!. Try your skills with these questions :   Recursive arrays and multi-dimensional arrays are one and the same. (PHP and MySQL)   The \"cache_dir\" tag of the squid configuration has a default of /var/spool/squid. (Linux)

	WeberForums.com Forum Index -> MySQL General	All times are GMT + 2 Hours
Page 1 of 1

Jump to: Select a forum PHP Forums----------------PHP GeneralPHP MySQL Jobs and ProjectsPHP Articles Tutorials and ScriptsWhy Use PHPPEARPHP Books MySQL Forums----------------MySQL General Apache Forums----------------Apache General Web Development Forums----------------Java Script / AJAXSearch Engine Optimization (SEO)Cascading Style SheetsHTMLXML & XSL Graphics & Design----------------Theory related web designWeb Design Security Forums----------------Security Linux Forums----------------Linux General Web Development Misc----------------Hosting Related Miscellaneous----------------Feedback & TestimonialsMisc  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