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 vote117 views1 answer
Sql server rtrim everything after character
SQL
7 votes104 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote103 views1 answer
Sql get guid
SQL
0 vote96 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote104 views1 answer
Check psql validity function
SQL
3 votes100 views1 answer
Postgresql cast
SQL
0 vote121 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
5 votes94 views2 answers
Create table
SQL
23 votes112 views3 answers
Sql where contains part of string
SQL
0 vote102 views1 answer
Postgresql create table with boolean column
SQL