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 vote110 views1 answer
Table infromation in sql server
SQL
0 vote93 views2 answers
Sql update from two different database
SQL
6 votes157 views3 answers
Rename column ORACLE
SQL
1 vote139 views1 answer
Load mysql dumb
SQL
2 votes168 views1 answer
How to create sql database
SQL
1 vote122 views1 answer
Alter table column size oracle
SQL
1 vote131 views1 answer
Sql select table header
SQL
0 vote119 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote125 views1 answer
How to open mysql in docker
SQL
0 vote134 views1 answer
Mysql dump for selected row
SQL