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

3 votes186 views1 answer
Uppercase and lowercase in sql
SQL
0 vote258 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote193 views1 answer
Oracle sql log to console
SQL
1 vote206 views2 answers
Foreign key set 0
SQL
-2 votes273 views1 answer
Mysql not empty
SQL
0 vote187 views1 answer
Sql date d'aujourd'hui
SQL
0 vote216 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote274 views1 answer
How to add auto increment primary key
SQL
2 votes281 views1 answer
Mariadb json select
SQL
1 vote255 views1 answer
Varchar plsql
SQL