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 votes147 views3 answers
Row number mysql
SQL
0 vote103 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
2 votes155 views2 answers
Checking data type in sql server
SQL
5 votes157 views3 answers
Sql server utc to local
SQL
-1 vote142 views1 answer
Auto increment psql not primary key
SQL
0 vote152 views2 answers
Athena drop partition
SQL
8 votes177 views1 answer
Racle create auto increment column
SQL
2 votes141 views1 answer
Mysql sysdate - 1 day
SQL
0 vote146 views1 answer
Delete first row in sql
SQL
0 vote138 views1 answer
Pl sql join 3 tables
SQL