Mysql-delete语句
`
点击查看代码
删除2天之前的所有数据
delete From lkt_files_record where DATE(add_time) <= DATE(DATE_SUB(NOW(),INTERVAL 2 day));
本文来自博客园,作者:青喺半掩眉砂,转载请注明原文链接:https://www.cnblogs.com/xiaoguo-java/p/16625338.html
`
删除2天之前的所有数据
delete From lkt_files_record where DATE(add_time) <= DATE(DATE_SUB(NOW(),INTERVAL 2 day));
本文来自博客园,作者:青喺半掩眉砂,转载请注明原文链接:https://www.cnblogs.com/xiaoguo-java/p/16625338.html