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

4 votes332 views2 answers
Select todays data postgres query
SQL
0 vote375 views1 answer
Mysql récupérer le code création de vue
SQL
3 votes346 views2 answers
Pl sql escape '
SQL
3 votes366 views2 answers
Oracle apex charging debug
SQL
0 vote372 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote366 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote359 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
1 vote314 views1 answer
Alter user mysql native password
SQL
10 votes344 views3 answers
Insert into auto increment mysql
SQL
0 vote357 views1 answer
Sql waitfor
SQL