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

9 votes105 views4 answers
Add primary key to existing table sql
SQL
5 votes108 views1 answer
Sql add column after another
SQL
0 vote73 views1 answer
Expose db in virtualbox
SQL
0 vote123 views1 answer
Pgadmin save data greyed out
SQL
0 vote117 views1 answer
"Hello User Name"
SQL
1 vote104 views1 answer
Setval pgsql
SQL
0 vote121 views1 answer
Sqlite3 pragma foreign keys
SQL
2 votes153 views1 answer
Remove foreign key constraints in postgres
SQL
2 votes120 views1 answer
Add new column not null sql server
SQL
0 vote102 views1 answer
Install mysql 8 linux
SQL