delete from tablename where DATE_FORMAT(accepttime,'%Y-%m-%d %H:%i:%s') < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
accepttime由于是long型的时间戳所以需要转格式
delete from tablename where DATE_FORMAT(accepttime,'%Y-%m-%d %H:%i:%s') < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
accepttime由于是long型的时间戳所以需要转格式