How to delete mysql row after time passes?

by

You can use PHP script and use cron job on your cpanel.

Example:

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.

enter image description here

More Related Contents:

  1. How to update multiple MySQL table entries with different id?
  2. Can’t insert data into mysql database using PHP [closed]
  3. which is better every user have a table or just a row [closed]
  4. How can I use PDO to fetch a results array in PHP?
  5. Fixing broken UTF-8 encoding
  6. MySQL check if a table exists without throwing an exception
  7. Export MySQL data to Excel in PHP
  8. MySQL – ignore insert error: duplicate entry
  9. Calculate age based on date of birth
  10. How to write a stored procedure using phpmyadmin and how to use it through php?
  11. Doing calculations in MySQL vs PHP
  12. Geo-Search (Distance) in PHP/MySQL (Performance)
  13. Call to a member function execute() on boolean in [duplicate]
  14. PHP mysql search multiple tables using a keyword
  15. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  16. Best practice: Import mySQL file in PHP; split queries
  17. Find Point in polygon PHP
  18. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  19. Setting a connect timeout with PDO
  20. How to build a JSON array from mysql database
  21. How to display a date as iso 8601 format with PHP
  22. How to generate unique id in MySQL?
  23. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  24. adding 30 minutes to datetime php/mysql
  25. Remotely connecting to a MySQL database
  26. Create table with PHP and populate from MySQL
  27. Difference between mysql_fetch_array and mysql_fetch_row?
  28. mysql_fetch_array skipping first row
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment