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

2 votes123 views1 answer
Query any digits record
SQL
-1 vote125 views3 answers
My sql alter table
SQL
2 votes118 views1 answer
Sql update alias
SQL
0 vote108 views1 answer
Describe in sqlite3
SQL
3 votes176 views4 answers
Sql interview questions
SQL
0 vote114 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote115 views1 answer
Sql contains vs like
SQL
0 vote147 views1 answer
Stop and start mysql
SQL
0 vote134 views1 answer
Doctors appointment
SQL
1 vote142 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL