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 vote150 views1 answer
T-sql conditional order by multiple columns
SQL
1 vote137 views1 answer
Select dba users oracle
SQL
0 vote175 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote192 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote134 views2 answers
T sql get foreign key
SQL
37 votes351 views3 answers
Sql check duplicate value in column
SQL
3 votes248 views1 answer
Ssh check mysql version
SQL
0 vote156 views1 answer
Sp in sql server
SQL
0 vote194 views1 answer
Mysql could not fetch tables
SQL
0 vote152 views1 answer
Update one column from another column in same table
SQL