sql trigger

Question

The system should be able to reorder items that are out of stock. I have a table called product and a column in it called Stock Count. i want to make a trigger that when the stock is zero for a product, the system must order an item. Could someone help me.

Answer 1

you can use update trigger to check if stock > 0

Answer 2

see https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
for examples