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

1 vote245 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote210 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote243 views1 answer
Pl/pgsql declare variable
SQL
0 vote255 views1 answer
Trigger stock phpmyadmin
SQL
0 vote300 views1 answer
Mysql collation portugues brasil
SQL
0 vote213 views4 answers
User defined function sql
SQL
1 vote198 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote316 views1 answer
Insensitive case match sqlalchemy
SQL
3 votes257 views1 answer
Sql several or
SQL
10 votes193 views1 answer
Oracle view dependencies
SQL