I'm a student and I'm creating my simple inventory system.
I want to subtract my 2 tables orders
and product
.
If the order has been received the order_quantity
should subtract to product_quantity
...
Is it possible if I use MYSQL triggers?
I'm a student and I'm creating my simple inventory system.
I want to subtract my 2 tables orders
and product
.
If the order has been received the order_quantity
should subtract to product_quantity
...
Is it possible if I use MYSQL triggers?