Run a mySQL query as a cron job?

by

I personally find it easier use MySQL event scheduler than cron.

Enable it with

SET GLOBAL event_scheduler = ON;

and create an event like this:

CREATE EVENT name_of_event
ON SCHEDULE EVERY 1 DAY
STARTS '2014-01-18 00:00:00'
DO
DELETE FROM tbl_message WHERE DATEDIFF( NOW( ) ,  timestamp ) >=7;

and that’s it.

Read more about the syntax here and here is more general information about it.

More Related Contents:

  1. Permission denied with bash.sh to run cron
  2. Bash script to run php script
  3. How to update multiple MySQL table entries with different id?
  4. Can’t insert data into mysql database using PHP [closed]
  5. which is better every user have a table or just a row [closed]
  6. How to run deprecated php codes on the latest XAMPP [duplicate]
  7. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  8. How can I use PDO to fetch a results array in PHP?
  9. Is closing the mysql connection important?
  10. MySQL check if a table exists without throwing an exception
  11. Shortcomings of mysql_real_escape_string?
  12. Alternative to mysql_real_escape_string without connecting to DB
  13. HTML – Change\Update page contents without refreshing\reloading the page
  14. Calculate age based on date of birth
  15. How to write a stored procedure using phpmyadmin and how to use it through php?
  16. Doing calculations in MySQL vs PHP
  17. Geo-Search (Distance) in PHP/MySQL (Performance)
  18. Post and get at the same time in php
  19. How to solve General error: 2006 MySQL server has gone away
  20. ini_set, set_time_limit, (max_execution_time) – not working
  21. How to build a JSON array from mysql database
  22. What is the best way to insert multiple rows in PHP PDO MYSQL?
  23. How to display a date as iso 8601 format with PHP
  24. How to generate unique id in MySQL?
  25. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  26. adding 30 minutes to datetime php/mysql
  27. Create table with PHP and populate from MySQL
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. PHP/MySQL Pagination

Leave a Comment