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 vote142 views1 answer
Oracle remove line breaks
SQL
0 vote196 views1 answer
Delete from IN subquery
SQL
2 votes130 views1 answer
Oracle create directory
SQL
0 vote156 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote110 views1 answer
Raven ql select count
SQL
4 votes138 views1 answer
SQL order random
SQL
0 vote147 views1 answer
Big table in mysql
SQL
1 vote198 views1 answer
Sqlite show columns in table
SQL
1 vote103 views1 answer
Mysql collation
SQL
0 vote137 views2 answers
Sqlite unix timestamp
SQL