Delete From t_order where DATE(orderDate) <= DATE(DATE_SUB(NOW(),INTERVAL 30 day)) ; t_order 表名 orderDate 需要依据的时间字段