maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

Standard SQL has triggers FOR EACH STATEMENT, but MariaDB has not. I would use a stored procedure instead.

Regards
Federico


--------------------------------------------
Ven 13/11/15, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:

 Oggetto: [Maria-discuss] doubt trigger
 A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Venerdì 13 novembre 2015, 21:50
 
 hi guy, i'm with
 a doubt
 thre's a trigger to execute after
 insert/update/delete complete? not row by rowi
 want to change some tables and automatically execute a
 procedure to recalculate some values, but i will
 insert/update/delete many rows, that's why i want to
 execute it after query execution, but with  a CALL
 PROCEDURE()
 any idea?
 
 -- 
 Roberto Spadim
 
 
 -----Segue allegato-----
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp