A trigger that insures that the due date in the DetailRental

A trigger that insures that the due date in the DetailRental table is at least one day after the current date. The current date can be accessed by the getdate() function.

Solution

Trigger for UPDATE DetailRental table

Update the date field in table DetailRental

DELIMITER $$

CREATE TRIGGER `table_field` AFTER UPDATE ON `date` FOR EACH ROW

BEGIN

IF date > getdate()

THEN

update stetement query

END IF;

END$$

DELIMITER ;