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 vote265 views1 answer
Mysqli or pdo
SQL
0 vote342 views1 answer
Updating database in sql
SQL
0 vote309 views1 answer
Run postgresql dump to csv
SQL
0 vote335 views3 answers
Join
SQL
2 votes318 views1 answer
Grant revoke privileges to mysql username
SQL
4 votes320 views2 answers
Mysql alter table set column unique
SQL
0 vote341 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote307 views1 answer
Sqlalchemy query return only n results
SQL
0 vote343 views2 answers
Sql having multiple conditions
SQL
0 vote336 views1 answer
Sql update subtract value
SQL