在Navicat 中函数新建存储过程 begin delete from bn_hjy_order where (TO_DAYS(NOW()) - TO_DAYS(hjy_pay_time))>=30; end 然后在事件中定时