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 vote287 views1 answer
Sql convert unix time to date
SQL
13 votes279 views3 answers
Sql select from multiple tables without join
SQL
0 vote268 views1 answer
Sql cheetsheet
SQL
0 vote283 views1 answer
OFFSET consulta mysql
SQL
0 vote263 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
1 vote273 views1 answer
Mysql check table exists
SQL
1 vote261 views2 answers
Sql where is not number
SQL
0 vote293 views1 answer
Postgres list users and roles
SQL
0 vote279 views2 answers
How to set global time_zone in mysql
SQL
0 vote278 views2 answers
Soql last year
SQL