LAPAJTE QUERY

//PROCEDURE QUERY
DELIMITER ;;
CREATE PROCEDURE `get_status`(IN paket_id INT)
BEGIN
        SELECT id_paket, status FROM `isporaka`, `status_isporaka` WHERE id_paket = paket_id AND isporaka.id_status = status_isporaka.id_status;
     END;;
DELIMITER ;

//TRIGGER QUERY

INSERT INTO stat (OPIS_STAT, DATUM_STAT)
values (CONCAT("Inserted packet with id =",NEW.Id_paket, "and price = ", NEW.FK_cena_paket), NOW())