MySQL daily check and update – Education Career Blog

Is possible to create a routine or procedure that can automatic everyday check a date in a table.

To be simpler : I want to check if the date on a user have permitions to enter a site and when the date pass want to make the user field activated false.

routine daily
check if (todaydate < dateclient) then
client.activated= false

Thanks for all the help.


Yes, this should be a simple UPDATE query. Something like the following:

SET Activated = 'false'
WHERE NOW() < dateclient

You would obviously need to modify this for your schema and then schedule it to run daily using cron or an alternative scheduler of your choice.


Creating the routine is simple enough, but to run it on a daily basis you’ll need to wrap it in a cronjob (*nix) or Scheduled Task (Windows). The routine, unfortunately, cannot execute itself – and to the best of my knowledge MySQL server does not possess the ability to run routines at scheduled intervals.

Leave a Comment