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 votes181 views1 answer
Oracle user quota on tablespace
SQL
0 vote182 views1 answer
Oracle call a function in a insert statement
SQL
-2 votes178 views3 answers
Sqlite reset autoincrement
SQL
0 vote192 views1 answer
Sql delete row from table where id
SQL
5 votes181 views3 answers
String concatenation sql server
SQL
1 vote180 views1 answer
Oracle check table space
SQL
0 vote192 views1 answer
How to get data from 2 database
SQL
5 votes197 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote202 views2 answers
Postgresql check privileges on schema
SQL
0 vote178 views1 answer
Call function in query sql server
SQL