Bug #56447 Trigger to listen for events in tables in another schema
Submitted: 1 Sep 2010 12:26 Modified: 16 Sep 2010 10:40
Reporter: marco giannantonio Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: triggers

[1 Sep 2010 12:26] marco giannantonio 
Description:
At the moment it is not possible to setup a trigger listening to a table in another schema. 

This feature would be extremely useful. 

How to repeat:
CREATE TRIGGER 
	`mytrigger` 
BEFORE INSERT ON schema.table
FOR EACH ROW 
BEGIN   
	-- ...
END;
[16 Sep 2010 10:40] Susanne Ebrecht 
Triggers always belong to the schema.

****

CREATE TRIGGER 
	`mytrigger` 
BEFORE INSERT ON schema.table
FOR EACH ROW 
BEGIN   
	-- ...
END;

****

This already works fine just use:

CREATE TRIGGER 
	schema.`mytrigger` 
BEFORE INSERT ON schema.table
FOR EACH ROW 
BEGIN   
	-- ...
END;