MySQL Forums
Forum List  »  French

Variable "CURRENT_BASE" dans un Trigger
Posted by: Laurent MOULIS
Date: October 16, 2006 03:16AM

Bonjour,

J'ai besoin de mettre en place des triggers qui centralisent des informations de plusieurs bases sur une base globale ...

Contrainte : j'ai besoin de stocker dans la base globale le nom de la base "fille" ...

Existe-t-il une variable du genre CURRENT_BASE qui permettrait d'ecrire un truc du genre :

CREATE TRIGGER ma_base.mon_trigger BEFORE INSERT
ON ma_base.ma_table FOR EACH ROW
INSERT INTO ma_base_globale.ma_table_globale SELECT CURRENT_BASE FROM blabla ...

et ou "CURRENT_BASE" prendrait la valeur de "ma_base" ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Variable "CURRENT_BASE" dans un Trigger
4249
October 16, 2006 03:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.