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 vote355 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote346 views1 answer
Print mysql
SQL
0 vote332 views1 answer
Pgadmin see indexes
SQL
0 vote328 views1 answer
Redudancy in SQL
SQL
0 vote321 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote329 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote332 views2 answers
Mysql join two tables
SQL
1 vote348 views1 answer
Select dba users oracle
SQL
4 votes325 views2 answers
Mysql show indexes on table
SQL
0 vote367 views4 answers
Open mysql port bitnami tomact
SQL