Home >Backend Development >PHP Tutorial > 求mysql一条命令，距离现在N天如何写
求mysql一条命令，距离现在N天如何写
- WBOYOriginal
- 2016-06-13 12:51:04927browse
求mysql一条命令，距离现在N天怎么写？
表table
列time 数据写入时间
现在我想删除距离今天为止 大于3天的数据，求命令。
mysql
------解决方案--------------------
youdatetime------解决方案--------------------
delete from tbl_name where datefield
------解决方案--------------------
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
Previous article： 小弟我在本地写完程序放到了服务器上，发现服务器上model返回的结果和本地是不同的 Next article： 关于图片上传，文件名中文显示乱码有关问题