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

3 votes344 views1 answer
APEX elapsed time
SQL
0 vote333 views2 answers
Postgresql change user role grant
SQL
5 votes328 views3 answers
Sql max value in column
SQL
0 vote344 views1 answer
What is initial catalog in sql connection string
SQL
2 votes331 views2 answers
Enable foreign key checks postgres
SQL
0 vote312 views1 answer
Count the table indatabase
SQL
12 votes320 views4 answers
Mysql version query
SQL
2 votes318 views2 answers
Mysql date range
SQL
0 vote320 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
6 votes319 views4 answers
Eloquent to sql with bindings
SQL