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 vote170 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote172 views1 answer
Best sql collation
SQL
1 vote200 views1 answer
Oracle columns table
SQL
1 vote185 views3 answers
Update from select sqlite
SQL
0 vote194 views1 answer
Delete hangfire retries list
SQL
9 votes168 views6 answers
Sql add column with default value
SQL
2 votes181 views4 answers
Sql query interview questions
SQL
0 vote186 views1 answer
Into operator in sql
SQL
9 votes163 views2 answers
Oracle all tables in schema
SQL
34 votes188 views5 answers
Oracle alter table add column
SQL