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

0 vote194 views1 answer
1 column values in to 1 single row in sql
SQL
1 vote187 views1 answer
Sql server select rows by distinct column
SQL
0 vote217 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote197 views1 answer
Moodle query item quiz
SQL
1 vote194 views1 answer
Ilike for date postgres
SQL
51 votes305 views6 answers
Change column name sql
SQL
0 vote337 views1 answer
Mysql failed to login as root@localhost
SQL
1 vote221 views1 answer
Sql list all procedures
SQL
0 vote213 views1 answer
TSQL convert csv to table
SQL
7 votes205 views1 answer
Oracle pagination query offset
SQL