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

1 vote187 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote183 views1 answer
Difference between varchar and varchar2
SQL
0 vote273 views1 answer
Do you know sql
SQL
0 vote185 views1 answer
Mysql count unique in group statement
SQL
16 votes223 views1 answer
Mysql smallint range
SQL
0 vote192 views1 answer
Interview experience as a call?
SQL
1 vote196 views1 answer
Psql connections
SQL
0 vote171 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote208 views1 answer
Mysql persistence.xml
SQL
0 vote240 views1 answer
Set open file limit mac catalina mysql
SQL