triggers in mysql

srinathbtech · #1 (**permalink**) 10-06-08, 09:43

hi,
i am newbie to mysql triggers,
can any one help me how to create/call trigger from application

thanks
sri

gvee · #2 (**permalink**) 10-06-08, 09:47

Triggers cannot be called from an application (per s&#233

.
Triggers are set to execute on INSERT, UPDATE and DELETE events on the specified object they are created for.

Perhaps you are thinking of Stored Procedures / Functions?

srinathbtech · #3 (**permalink**) 10-07-08, 02:27

Quote:

Originally Posted by georgev

Triggers cannot be called from an application (per sé).
Triggers are set to execute on INSERT, UPDATE and DELETE events on the specified object they are created for.

Perhaps you are thinking of Stored Procedures / Functions?

hi ,
yes you are right , i was pondering on how to call/create procedures/functions

help me !!

healdem · #4 (**permalink**) 10-07-08, 02:43

wonder if Google knows anything?

BargainPredator · #5 (**permalink**) 10-07-08, 02:46

Create a procedure :

Code:

DELIMITER $

CREATE PROCEDURE aProcdure(aInput INT)
BEGIN

    IF aInput = 4 THEN
        ...
    ELSE
        ....
    END IF;

END$

DELIMITER ;

CAll a procedure :

Code:

CALL aProcdure(1);

Create a function :

Code:

DELIMITER $

CREATE FUNCTION aFunction(aInput INT) RETURNS INT
BEGIN
    DECLARE aValue INT; 
    ...
    
    RETURN aValue;
END$

DELIMITER ;

Call a function :

Code:

SELECT aFunction(1);

Internet Services

Web Development

Digital Marketing

Consumer Tech