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:

UPDATE Client
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