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 vote160 views1 answer
How to open mysql in docker
SQL
5 votes157 views1 answer
Oracle list functions
SQL
5 votes129 views1 answer
Mysql get last day of month
SQL
1 vote133 views4 answers
Between vs in sql
SQL
0 vote141 views1 answer
How to order result of subquery in select
SQL
3 votes142 views2 answers
Mysql create timestamp column
SQL
0 vote167 views1 answer
IS THEre any difference between using default and := in plsql
SQL
5 votes138 views2 answers
Oracle to_timestamp
SQL
0 vote123 views1 answer
Ms sql unique
SQL
0 vote156 views1 answer
Sql select merge multiple values
SQL