mysql 删除30天之前的数据

Delete From table where DATE(datetime) <= DATE(DATE_SUB(NOW(),INTERVAL 30 day)) ;

table->表名

datetime->时间