Geek asks and answers

Mysql trigger not working

I created the following trigger, but did not execute it after inserting data

DELIMITER //
  CREATE TRIGGER sale_after_insert
AFTER INSERT
   ON ano_sale_join
FOR EACH ROW
 BEGIN
    INSERT INTO ano_sale_join.database_inventory (sale_id) values (NEW.sale_id);
    INSERT INTO ano_sale_join.database_inventory (sales_prod_id) values (NEW.sales_prod_id);
  END//
DELIMITER;
+3
source share
1 answer

You have a broken link database, and tablein the statements. They switched places.

This code code is incorrect:

INSERT INTO ano_sale_join.database_inventory (sale_id) values (NEW.sale_id);
INSERT INTO ano_sale_join.database_inventory (sales_prod_id) values (NEW.sales_prod_id);

Change them as:

INSERT INTO database_inventory.ano_sale_join(sale_id) values (NEW.sale_id);
INSERT INTO database_inventory.ano_sale_join(sales_prod_id) values (NEW.sales_prod_id);

Refer to :

+3
source

More articles:


All Articles