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

10 votes167 views2 answers
Tsql merge example
SQL
1 vote182 views1 answer
Age postgres
SQL
5 votes209 views2 answers
Mysql dump mysql db cli
SQL
0 vote246 views1 answer
Mariadb date equals to current_date plus days
SQL
6 votes183 views2 answers
Sql query to get the number of rows in a table
SQL
12 votes168 views4 answers
Mysql ifnull
SQL
0 vote211 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote169 views1 answer
Alasql delete column
SQL
0 vote306 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
-1 vote177 views3 answers
MySQL shutdown unexpectedly
SQL