2011年12月14日
mysql 触发器
摘要： beginSELECT a.location,a.flag into @loc,@flag FROM workdrawmst a where a.no=new.no;select count(*) into @c from locstock where loccode=@loc and stockid=new.stockid;if @c<1 theninsert into locstock (loccode,stockid,quantity) values (@loc,new.stockid,-@flag*new.qty);elseupdate locstock set quantity 阅读全文
posted @ 2011-12-14 10:33 Mose 阅读(155) 评论(0) 推荐(0)