Trigger vérifier stock

 
BEGIN
 
UPDATE `product` 
    SET `price` =  NEW.price
    , `quantity` = NEW.quantity 
    , date_modified = NOW() 
    WHERE `product_id` = NEW.product_id;
    AND price > NEW.price 
    AND quantity > 0
;
 
END

Source: developpez.net

Similar codes

0 vote136 views1 answer
Sql today at midnight
SQL
0 vote129 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote111 views1 answer
Mysql find db contarint
SQL
1 vote131 views1 answer
Sysdate in sql
SQL
0 vote107 views1 answer
Increment id in mysql
SQL
0 vote118 views2 answers
Execute stored procedure without db set
SQL
4 votes124 views4 answers
Pl sql output
SQL
0 vote117 views1 answer
How to insert same table data using mysql query
SQL
0 vote115 views1 answer
SQL authentication error
SQL
0 vote118 views1 answer
Json not contains mysql
SQL