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 vote331 views1 answer
Sql query to select even numbers
SQL
0 vote228 views0 answer
How to connect to datbase in springboot
SQL
0 vote322 views1 answer
Fetching data from mysqldb
SQL
0 vote350 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
2 votes318 views2 answers
Create table mysql integer NOT null
SQL
0 vote307 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote293 views1 answer
Mssql disable foreign key constraint
SQL
0 vote285 views1 answer
Sql get date from timestamp
SQL
11 votes254 views2 answers
Sql between date range
SQL
4 votes307 views6 answers
List all tables in postgres
SQL