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 vote128 views1 answer
Back up stored procedures mysql
SQL
16 votes146 views3 answers
Get count of duplicate records
SQL
3 votes124 views3 answers
Mysqldump: couldn
SQL
0 vote124 views1 answer
Sql count more than 1
SQL
4 votes121 views1 answer
Sql group by year
SQL
3 votes132 views1 answer
Stpop start psql server
SQL
0 vote150 views1 answer
How to check database engine in mysql
SQL
26 votes137 views2 answers
Mysql workbench download
SQL
0 vote139 views1 answer
Create a sql server database programmatically
SQL
0 vote135 views1 answer
Resullt all update knex mysql
SQL