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 vote165 views1 answer
Oracle sql listagg
SQL
5 votes202 views2 answers
Mysql dump mysql db cli
SQL
1 vote183 views2 answers
Rebuild index sql server
SQL
0 vote164 views1 answer
Pgsql is not permitted to log in
SQL
6 votes157 views4 answers
Delete table sqlite
SQL
0 vote344 views1 answer
Dublicate row sql
SQL
0 vote204 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
3 votes118 views4 answers
Show columns from table
SQL
0 vote151 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote198 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL