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

1 vote322 views1 answer
Age postgres
SQL
0 vote318 views1 answer
Alter check command
SQL
0 vote296 views1 answer
Psql check if value in array
SQL
10 votes314 views4 answers
Drop primary key
SQL
0 vote343 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
2 votes314 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote330 views3 answers
Postgresql get difference between two dates
SQL
1 vote365 views1 answer
STOP message of how many rows affected sql
SQL
0 vote301 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote297 views1 answer
Mariadb mysql root access denied
SQL