上传限时抢购商品，到期自动下架，修改数据库状态（添加定时任务）

DROP EVENT IF EXISTS `event_cuxiaogoods`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` EVENT `event_cuxiaogoods` ON SCHEDULE EVERY 1 MINUTE STARTS '2016-01-17 14:49:43' ON COMPLETION NOT PRESERVE ENABLE DO 

BEGIN
   update yc_goods set isSale =0  where goodsId in   (select goodsId from(select goodsId from yc_goods   where  datediff(now(),date_add(fabutime, interval huodongtime day))=0 ) a);

END
;;
DELIMITER ;

 

转载于:https://www.cnblogs.com/wrld/p/9768260.html