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 vote256 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote272 views1 answer
Oracle lower in where clause
SQL
0 vote257 views1 answer
Sql #region
SQL
0 vote247 views1 answer
Order by number of character in sql
SQL
3 votes259 views3 answers
Mysql order by list
SQL
0 vote272 views1 answer
Sqlite unique multiple columns
SQL
1 vote262 views1 answer
Rows to comma separated values in mssql
SQL
4 votes269 views4 answers
Oracle tablespace tables list
SQL
0 vote285 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote265 views1 answer
Case when with count and combining similar values in sql
SQL