SHOW VARIABLES LIKE 'event_scheduler';
DROP EVENT IF EXISTS `event_minute`;
DELIMITER ;;#更改结束符为;;
CREATE DEFINER=`root`@`localhost` EVENT `event_minute` ON SCHEDULE EVERY 1 MINUTE STARTS FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())) ON COMPLETION NOT PRESERVE ENABLE DO
BEGIN
UPDATE PLACE_STATUS SET STATUS=2 WHERE TIME_END=0 AND UNIX_TIMESTAMP(NOW())-LAST_HEARTBEAT_TIME>300
END
;;
DELIMITER ;