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 vote336 views1 answer
Last date for each user sql
SQL
0 vote303 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote313 views1 answer
SQL isnumeric DB2
SQL
1 vote328 views1 answer
Oracle repeat_interval 5 minutes
SQL
2 votes286 views1 answer
Latest record in sql
SQL
3 votes322 views3 answers
Remove all spaces from string sql
SQL
1 vote325 views1 answer
How to group by month using sql server
SQL
3 votes329 views2 answers
Current year sql
SQL
3 votes323 views1 answer
Oracle list invalid password ORA-01017
SQL
7 votes338 views1 answer
Mysql iif
SQL