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

7 votes329 views4 answers
How to reset the identity column in sql server
SQL
0 vote367 views1 answer
Mysql récupérer le code création de vue
SQL
1 vote433 views2 answers
Copy table in sql
SQL
1 vote366 views1 answer
Add many column to sap iq table
SQL
3 votes327 views3 answers
Print in pl sql
SQL
0 vote359 views1 answer
Merge clause with inner join
SQL
0 vote358 views1 answer
Postgresql concat string with separator
SQL
16 votes370 views1 answer
Sql comment'
SQL
1 vote367 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote375 views1 answer
Ajouter une clé etrangere mysql
SQL