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 vote129 views1 answer
FIND most frequent word in sql server
SQL
0 vote133 views1 answer
Oracle call a function in a insert statement
SQL
5 votes149 views1 answer
Oracle list functions
SQL
1 vote140 views1 answer
Round one decimal place mysql
SQL
0 vote168 views1 answer
Tsql cte in a transaction
SQL
0 vote175 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote141 views1 answer
Order by in codeigniter query builder
SQL
3 votes134 views1 answer
Create a table with an id in mysql
SQL
11 votes143 views2 answers
How to import mysql database command line
SQL
12 votes140 views1 answer
Docker run mysql image
SQL