Home  >  Article  >  Backend Development  >  求mysql一条命令,距离现在N天怎么写?

求mysql一条命令,距离现在N天怎么写?

WBOY
WBOYOriginal
2016-06-23 14:03:34846browse

表table
列time 数据写入时间
现在我想删除距离今天为止 大于3天的数据,求命令。


回复讨论(解决方案)

youdatetime

delete from tbl_name where datefield 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn