jsp - MySQL Query for Stock Level Process -


i doing inventory management system rn , found dead end on how should on stock increases , decreases.

heres thing, if ordered supplier , set stock status "ordered" stock remain unchanged , once change status "received" quantity of product/stock have order automatically added inventory table.

where , how should make make happened. lecturer said smth having trigger. , dont know how start. please give input on how should start. in advance.

i'm using tomcat 8.0, mysql , jsp.


Comments

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

java - Android – MapFragment overlay button shadow, just like MyLocation button -