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 vote173 views1 answer
Postgres change the name of schema
SQL
0 vote172 views1 answer
Sql remove non numeric characters
SQL
3 votes154 views1 answer
How to find names includes in sql
SQL
0 vote148 views1 answer
Acutal month year
SQL
0 vote141 views1 answer
Difference between cross apply and inner join
SQL
0 vote156 views1 answer
Psql get table data types
SQL
2 votes162 views1 answer
Pdo mysql insert
SQL
1 vote158 views1 answer
Mamp mysql path mac
SQL
0 vote160 views2 answers
Identity column in sql server
SQL
0 vote158 views1 answer
Mysql_union
SQL