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

1 vote159 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote196 views1 answer
Mysql select random rows large table
SQL
5 votes141 views1 answer
Mysql select greater than yesterday
SQL
0 vote171 views1 answer
.sql File Run in PSQL
SQL
0 vote171 views1 answer
Sql waitfor
SQL
0 vote160 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote144 views2 answers
How to combine diff colmun value using group by postgres
SQL
2 votes170 views1 answer
Sql OR
SQL
11 votes144 views5 answers
How to install sqlite3 python
SQL
5 votes135 views1 answer
Mysql get last day of month
SQL