有什么办法建立在不同的数据库触发器?我的要求是这样的: -
Is there any way to create triggers on different databases? my requirement is like:-
database: a1.db consist table: t1
database:a2.db consist table: t2
现在我必须在T1使用触发器(无论任何删除和更新操作)在t1上发生的值已经被插入到T2。
now i have to use trigger on t1 (whenever any delete and update operation) happens on t1 a value has to be inserted into t2.
在等待您的反馈...
waiting for your feedback...
我只能说针对MySQL的,但你应该能够做到这样的:
I can only speak for MySQL, but you should be able to do something like:
CREATE TRIGGER ad_t1 AFTER DELETE ON `a1.db`.t1
FOR EACH ROW
INSERT INTO `a2.db`.t2 VALUES (...)