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 vote262 views2 answers
Return the number of records in a single table mysql
SQL
6 votes306 views2 answers
Mysql convert timestamp to date
SQL
0 vote259 views1 answer
Connect postgresql using a connection string
SQL
1 vote273 views2 answers
Begin transaction in sql
SQL
2 votes251 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote299 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
3 votes252 views1 answer
Delete all content in table mysql
SQL
0 vote267 views1 answer
Dump db only triggers mysql
SQL
0 vote281 views3 answers
Fetlife
SQL
0 vote288 views1 answer
Sql: extract day text from datetime value
SQL