How to Automate Deleting MySQL Rows Based on Date Comparison?

Automating MySQL Row Deletion Based on Date Comparison

Your request involves purging database rows where a "Date" field indicates a past date. To achieve this, you can utilize a PHP script alongside a cron job.

MySQL Query:

The PHP script will execute the following MySQL query:

<code class="php">mysql_query("DELETE FROM your_table_name WHERE Date < NOW()");

This query selects and deletes rows from the specified table ("your_table_name") where the "Date" values are earlier than the current date.

PHP Script:

<code class="php"><?php
include 'your_db_connection';
mysql_query("DELETE FROM your_table_name WHERE Date < NOW()");
?></code>

• Create a PHP file containing this script and save it as "cronjobcommand.php".
• Replace "your_db_connection" with the code necessary to establish the connection to your MySQL database.

Cron Job Setup:

In your control panel (e.g., cPanel), set up a cron job that executes "cronjobcommand.php" at the desired time, such as midnight.

This automated process will periodically clear out outdated rows from your database, ensuring they meet the date-based criteria you have specified.

The above is the detailed content of How to Automate Deleting MySQL Rows Based on Date Comparison?. For more information, please follow other related articles on the PHP Chinese website!