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 vote183 views1 answer
Sql server select value large text
SQL
0 vote183 views1 answer
Left join vs inner join performance
SQL
3 votes206 views3 answers
Update con select postgresql
SQL
7 votes215 views3 answers
Sql server check if temp table exists
SQL
0 vote187 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote176 views1 answer
Restore backupfile discourse
SQL
0 vote192 views1 answer
Mysql get first 2 characters of string
SQL
0 vote198 views1 answer
Minus equivalent in my sql
SQL
1 vote190 views2 answers
Sql drop multiple columns if exists
SQL
2 votes181 views1 answer
Date_format for time sql
SQL