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

11 votes312 views3 answers
Sql_mode=only_full_group_by
SQL
1 vote306 views1 answer
Size of all tables in a schema oracle
SQL
17 votes359 views4 answers
Show all tables in oracle
SQL
0 vote275 views1 answer
Oracle last connection
SQL
0 vote319 views1 answer
Mysql add to number
SQL
2 votes299 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote307 views2 answers
How to install mssql on mac
SQL
58 votes520 views4 answers
Mysql drop column
SQL
2 votes304 views1 answer
Sqlite3 show columns name
SQL
0 vote344 views1 answer
Alternative for LIMIT sql
SQL