DELIMITER $$
USE `gantrycranes_qqctn`$$
CREATE DEFINER=`root`@`%` PROCEDURE `deleteVesselInfo`()
BEGIN
delete from berth_plan where (TO_DAYS(NOW()) - TO_DAYS(create_time))>=15;
delete from vessel_listing where (TO_DAYS(NOW()) - TO_DAYS(create_time))>=15;
END$$
DELIMITER ;
;
CREATE EVENT deleteVesselInfo
ON SCHEDULE EVERY 1 day STARTS '2021-04-28 00:00:00' do call deleteVesselInfo();