2
I would like to know how I can make a triggers to mysql where ex a person enters to deliver a product in the company, in the table movivisitaservico this table is of movement of entry of people the time that each of this specialty of delivery can be is defined in the table of specialty, in the movement when I enter with the date (date of entry) and Horae (time of entry) would have to check the time that the courier is within the company to issue an alert for a call to be made to the person who is receiving that visitor that his or her time had already expired ex datae = 13/10/2016, Horae = 23:45 min, in the specialty table this defined that this delivered can only stay 40 min inside the company that means that when it was 00:25 if that person had not left I must receive an alert that ran the time.