Everyday I need to UPDATE a column automatically:
update client_invoices set x6 = datediff(x4, date_due)
Im using an event in mysql but everytime the hosting company updates the server the Event scheduler status is turned off.
Any way I can perform this without scheduling events?