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 vote119 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
4 votes79 views1 answer
Oracle sleep
SQL
2 votes128 views2 answers
Postgres timestamp to datetime
SQL
0 vote149 views1 answer
Set classpath for mysql-connector.jar
SQL
9 votes125 views1 answer
Oracle get table schema
SQL
0 vote112 views1 answer
How to order result of subquery in select
SQL
-2 votes121 views1 answer
Create trigger syntax
SQL
5 votes124 views1 answer
Oracle get foreign keys on table
SQL
1 vote134 views1 answer
Python clean sql string
SQL
3 votes113 views3 answers
Mysqldump: couldn
SQL