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 vote331 views1 answer
Multiple count in sql
SQL
1 vote362 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote339 views1 answer
Mysql get only the field names in a table
SQL
0 vote315 views2 answers
2nd max salary query in sql
SQL
0 vote346 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote353 views1 answer
Split string by comma in sql server
SQL
0 vote340 views1 answer
Mysql multiple primary keys
SQL
0 vote550 views1 answer
Get first match in each group mysql query
SQL
0 vote331 views1 answer
Ms sql database data size
SQL
3 votes329 views2 answers
Mysql create database
SQL