mysql create a trigger in a database listening to table changes in a different database

Question

something like:

CREATE TRIGGER
       schema1.triggername
AFTER INSERT ON schema2.table
FOR EACH ROW
BEGIN
       ;
END;

ERROR 1435 (HY000): Trigger in wrong schema

Ike Walker · Accepted Answer · 2010-09-01 19:06:53Z

3

The trigger needs to be in the same schema as the table you are inserting to, but it can access tables in other schemas.

Using your example:

CREATE TRIGGER schema2.triggername
AFTER INSERT ON schema2.the_table
FOR EACH ROW
  INSERT INTO schema1.the_table values (...);

answered Sep 1, 2010 at 19:06

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yes, thanks but I want the trigger (all the triggers actually) in a different schema than the tables.

this fixed my error after using create trigger schema2.triggername