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 vote325 views1 answer
Metada in sql
SQL
5 votes362 views1 answer
Mysql created at yesterdau
SQL
0 vote361 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote353 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote344 views1 answer
Sqlite create index
SQL
0 vote386 views1 answer
Reindex mssql table
SQL
4 votes337 views1 answer
Oracle show errors compilation
SQL
0 vote353 views1 answer
Restore backup mysql .gz
SQL
0 vote307 views1 answer
How to see the content of tables in pgadmin
SQL
11 votes372 views6 answers
Mysql else if
SQL