Trigger stock phpmyadmin

DELIMITER $$
CREATE TRIGGER invlevel_AUPD
AFTER UPDATE ON invlevel 
FOR EACH ROW
BEGIN
  IF NEW.quantity < 20 THEN 
    INSERT INTO orders (productid, amount)
    SELECT productid, amount 
      FROM reorder 
     WHERE productid = NEW.productid;
  END IF;
END$$
DELIMITER ;

Source: stackoverflow.com

Similar codes

-2 votes187 views1 answer
Modify column name in tsql
SQL
1 vote221 views1 answer
Mysql last year
SQL
0 vote190 views1 answer
Postgres where
SQL
0 vote182 views1 answer
Oracle get running queries
SQL
0 vote202 views1 answer
Select from column mysql
SQL
3 votes147 views1 answer
How to get list of synonyms in oracle
SQL
0 vote184 views1 answer
Install mysql 8 linux
SQL
0 vote208 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
1 vote213 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote201 views1 answer
ACCEPT nome PROMPT on oracle
SQL