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

3 votes356 views5 answers
Duplicate table sql
SQL
0 vote343 views1 answer
Oracle table free space
SQL
2 votes362 views1 answer
Sql server find columns list in tables
SQL
0 vote329 views1 answer
Mysql coonect sample code
SQL
1 vote355 views3 answers
Connect to mysql c# connection string C#
SQL
4 votes331 views1 answer
Id primary key auto generated
SQL
0 vote336 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote342 views1 answer
Full outer join in mariadb mysql
SQL
2 votes322 views1 answer
Sql alchemy or
SQL
0 vote343 views1 answer
Sql query tags
SQL