Forums

Can not use event_scheduler in MySQL

Hi, I am doing one code where I have to trigger one event and update my database with that. I know you guys have provided scheduler but I also kind of need to execute some queries in MySql with my time intervals and set some data. so the thing is I can create scheduled event but I can not execute it. Can I do that? For example , In normal MySQL

SET GLOBAL event_scheduler = ON|

we usually execute this then it starts working.

That's not something we can support in our current MySQL system I'm afraid. You might be able to achieve something like that by using postgres -- we use a different multitenancy model, so your user accounts have full super permissions in postgres -- or look into whether you can achieve it with the pythonanywhere scheduler...