MySQL Forums
Forum List  »  Triggers

MySQL to trigger update statement on a specific day & time
Posted by: Bernard Bailey
Date: July 18, 2021 11:44PM

Hi team,

I have a requirement in MySQL to trigger an update statement on a calendar table on a specific day & time.

I understand triggers can only work on the basis of a BEFORE or AFTER state during an update of a field in a table.

I can not find anywhere for a method to cause a table update, unless I use a cron job.

Are there any MySQL tools that can run a sql statement on the specific day of the week and time?

Or is there a work around which will achieve the same result?

All assistance is appreciated.

Cheers
Bernard Bailey

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL to trigger update statement on a specific day & time
160
July 18, 2021 11:44PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.