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

1 vote225 views1 answer
Loading local data is disabled mysql
SQL
1 vote217 views2 answers
Mysql SELECT
SQL
1 vote245 views3 answers
Java.sql.sqlexception: access denied for user
SQL
1 vote289 views1 answer
Mysql default port
SQL
0 vote248 views1 answer
Normalization in database
SQL
0 vote250 views1 answer
Group by join columns per table
SQL
0 vote236 views1 answer
SQL Server Altering Column to be Unique
SQL
1 vote239 views1 answer
Decalre temp table sql
SQL
8 votes221 views3 answers
Mysql alter table add index
SQL
0 vote222 views1 answer
Select from 3 tables one is empty
SQL