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

0 vote207 views1 answer
Select last 2 characters sql
SQL
0 vote202 views1 answer
Convert rows into columns in oracle
SQL
2 votes190 views1 answer
Node and mysql like
SQL
10 votes258 views4 answers
Join multiple tables in sql
SQL
0 vote175 views2 answers
Influxdb delete measurement based on date
SQL
2 votes207 views1 answer
Apex date today add days
SQL
9 votes212 views3 answers
Import DB through mysql console
SQL
0 vote204 views1 answer
Cast as decimal postgresql
SQL
0 vote213 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote233 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL