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 vote290 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
3 votes311 views2 answers
Sqlite show table structure
SQL
0 vote286 views1 answer
Php get closest location by latitude longitude
SQL
0 vote315 views1 answer
Mysql change default collation
SQL
17 votes333 views3 answers
Postgresql list users
SQL
0 vote278 views1 answer
Mysql Error Code: 1005
SQL
0 vote285 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
3 votes289 views2 answers
Mysql create timestamp column
SQL
0 vote305 views1 answer
Querry mysql by 2 columns
SQL
3 votes292 views2 answers
Mysql select database
SQL