I would like to know how I can make a triggers for mysql where for example 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 one of that specialty of delivery can stay is defined in the specialty table, in the movement when entering the datee (date of entry) and Horae (time of entry) would have to verify the time that the deliveryman is inside the company to issue an alert so that a connection was made to the person that is receiving this visitor that his time has 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 should receive an alert that blew the time.
