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 vote307 views1 answer
Convert to hexadecimal sql
SQL
0 vote324 views1 answer
Sql show founctions
SQL
0 vote283 views1 answer
Drop unique
SQL
1 vote343 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote256 views0 answer
SQL
1 vote288 views2 answers
How to enable error squiggles in vs code
SQL
0 vote340 views2 answers
Sql query print strings and int
SQL
0 vote297 views1 answer
How to query without duplicate rows in sql
SQL
0 vote289 views1 answer
Start and stop mysql
SQL
6 votes285 views1 answer
Oracle trigger after logon on schema
SQL