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 vote189 views1 answer
Sql select without column name
SQL
0 vote134 views2 answers
Azure sql-datenbank
SQL
0 vote144 views1 answer
How to check the port of mysql installation in mac
SQL
6 votes140 views3 answers
Mysql server is not starting xampp
SQL
11 votes133 views2 answers
Having clause
SQL
1 vote140 views1 answer
Mysql best tutorial for beginners
SQL
0 vote155 views1 answer
Show tables in cassandra cql
SQL
1 vote161 views1 answer
Convert to hexadecimal sql
SQL
3 votes154 views1 answer
Postgres add not null to existing column
SQL
8 votes161 views2 answers
Select current_timestamp - interval '3 days';
SQL