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

2 votes228 views1 answer
Sql server case sensitive search
SQL
12 votes208 views1 answer
How to change the value of a table in sql
SQL
0 vote207 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote227 views1 answer
Sql reverse order of results
SQL
2 votes214 views1 answer
Sql server conection string
SQL
39 votes229 views5 answers
Sql drop column
SQL
1 vote210 views1 answer
Encrypt password postgresql
SQL
0 vote233 views1 answer
Repeatable read trong sql server
SQL
0 vote214 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote223 views1 answer
Oracle table free space
SQL