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

2 votes388 views1 answer
Q operator in oracle
SQL
0 vote337 views1 answer
Sql select rows between 1000 and 2000
SQL
2 votes377 views5 answers
Install postgresql 10 centos 7
SQL
0 vote343 views1 answer
Oracle synonym procedure
SQL
3 votes341 views1 answer
Mysql replace string in table
SQL
0 vote383 views1 answer
Create synonym for dblink in oracle
SQL
19 votes375 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote382 views1 answer
Sql create and grant user access to database
SQL
1 vote347 views1 answer
Sql convert month name to number
SQL
-1 vote359 views1 answer
How to dump .csv file into mysql
SQL