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

11 votes310 views1 answer
Oracle view source
SQL
0 vote305 views1 answer
How to to get time in sql
SQL
1 vote302 views1 answer
Mysql data from file
SQL
11 votes286 views1 answer
Ddl materialized view
SQL
1 vote297 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote277 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote298 views1 answer
Drop constraint in ms sql
SQL
1 vote290 views1 answer
Select if then postgresql
SQL
4 votes345 views4 answers
Mysql get date from datetime
SQL
3 votes294 views1 answer
Oracle user privileges
SQL