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 vote264 views1 answer
How to find date from date table in sql
SQL
1 vote267 views1 answer
Liquibase alter column type / length
SQL
0 vote240 views1 answer
Get schema of table sql
SQL
20 votes221 views5 answers
Mysql reset auto increment to 1
SQL
0 vote258 views1 answer
Java nosql sort
SQL
3 votes217 views3 answers
Docker create postgresql database
SQL
0 vote284 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote212 views1 answer
Sql auto timestamp
SQL
0 vote228 views1 answer
Sql grant select only
SQL
0 vote238 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL