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