问题描述
我不知道从哪里开始与这一个：
I have no idea where to start with this one:
我有一个数据库，用于存储帖子ID 和日期。
I have a database that stores postID and Date.
我想要做的是有我的网站自动删除所有行日期不到今天。该脚本可以没有任何用户输入的。没有按钮点击，什么都没有。该脚本必须在午夜运行的每一天。
What I want to do is have my website auto delete all rows where Date is less than today. This script can't have any user input at all. No button clicks, nothing. The script must run every day at midnight.
我一直在到处找东西做这个的地方，我发现绝对没有。
I've been looking all over the place for something that does this and I've found absolutely nothing.
推荐答案
您可以使用PHP脚本，并在您的cPanel使用cron作业。
You can use PHP script and use cron job on your cpanel.
例如：
cronjobcommand.php
cronjobcommand.php
<?php
include 'your_db_connection';
mysql_query("DELETE FROM your_table_name WHERE Date < NOW()");
?>
我已经附在下面的截图为您更多的参考。
I have attached a screenshot below for your more reference.
这篇关于如何删除mysql的行时间过后？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！