mysql 删除 一天前 创建 的数据,计算时间差

DELETE from table_name WHERE  TIMESTAMPDIFF(SECOND ,CREATE_TIME,now() ) >  24*60*60

　　

 

---

https://www.cnblogs.com/wanghx-0713/p/8080571.html