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

8 votes169 views1 answer
Mysql restore database
SQL
0 vote158 views1 answer
Drop procedure sql
SQL
17 votes179 views6 answers
Sql current date
SQL
0 vote118 views1 answer
Mysql offset from bottom
SQL
0 vote162 views1 answer
Get substract count sql
SQL
0 vote148 views1 answer
Implizite joins sql
SQL
0 vote170 views1 answer
Mysql get nth highest
SQL
0 vote159 views1 answer
Sql find table by name
SQL
-2 votes162 views1 answer
Mysql see users and passwords
SQL
1 vote103 views1 answer
Athena query timestamp greater than
SQL