如果想要定时做一些数据库操作可以用事件调度
MYSQL
CREATE EVENT `t100019_he_tong_dao_qi` ON SCHEDULE EVERY 1 HOUR STARTS '2007-02-10 23:59:00' ON COMPLETION NOT PRESERVE ENABLE DO update t100019 set c100139='到期' where c100138<=CURRENT_DATE
这是:从'2007-02-10 23:59:00'每过1小时 执行“update t100019 set c100139='到期' where c100138<=CURRENT_DATE”这句SQL命令