trigger

DELIMITER //
DROP TRIGGER IF EXISTS my_insert_trigger//
CREATE DEFINER=root@localhost TRIGGER my_insert_trigger
    AFTER INSERT ON `promene`
    FOR EACH ROW

BEGIN
    CALL set_aktivan_procedura(pid);
END//
DELIMITER ;


DELIMITER //
DROP TRIGGER IF EXISTS my_update_trigger//

CREATE DEFINER=root@localhost TRIGGER my_update_trigger
    AFTER UPDATE ON `promene`
    FOR EACH ROW
BEGIN
    -- Call the common procedure ran if there is an INSERT or UPDATE on `promene`
    CALL set_aktivan_procedura(pid);
END//
DELIMITER ;


DELIMITER //
DROP PROCEDURE IF EXISTS set_aktivan_procedura//

CREATE DEFINER=root@localhost PROCEDURE set_aktivan_procedura( out aktivan tinyint)
READS SQL DATA
BEGIN
case
when pdo IS NOT NULL then
set `aktivan` = 1;

when pdo IS NULL  then
set `aktivan` = 0;


end case;
    -- Write your MySQL code to perform when a `promene` row is inserted or updated here

END//
DELIMITER ;