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

4 votes192 views1 answer
Oracle show error line number
SQL
3 votes231 views1 answer
Unsigned int in mysql
SQL
4 votes185 views1 answer
Psql get sequences
SQL
0 vote211 views1 answer
Mysql local password denied
SQL
2 votes179 views2 answers
Join update query in sql
SQL
0 vote205 views1 answer
Criteria builder select subset of column
SQL
0 vote183 views1 answer
Report in database
SQL
33 votes197 views6 answers
Change column name in mysql
SQL
3 votes217 views1 answer
Oracle user quota on tablespace
SQL
0 vote255 views1 answer
IS THEre any difference between using default and := in plsql
SQL