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.
check if (todaydate < dateclient) then
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.