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 vote225 views1 answer
Postgresql last element of array
SQL
1 vote224 views1 answer
Oracle duration between timestamps
SQL
0 vote241 views2 answers
Mysql set foreign_key_checks=0
SQL
2 votes193 views1 answer
Latest record in sql
SQL
9 votes242 views3 answers
Mysql run sql file
SQL
9 votes214 views3 answers
Mysql get last id
SQL
1 vote223 views1 answer
Import sql file mysql commadn line
SQL
0 vote229 views1 answer
Django mssql backend
SQL
0 vote244 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote221 views1 answer
Sql select first and last record of each group
SQL