CODEWITHSUNDEEP
mysqleventsscheduler
Micha93
Micha93

Reputation: 668

is there a way to schedule mysql events on mysql 5.0 and older?

I hope you can help me very quickly. Is there a way how I can schedule events in mysql 5.0?

In Version 5.1 and newer you can do something like this

SET GLOBAL event_scheduler = 1; 
CREATE EVENT IF NOT EXISTS "event_name" 
ON SCHEDULE AT 'datetime' DO UPDATE "tablename" 
SET "column" = 'value' WHERE id = "id"

Are there a solution for older versions?

I know that I can update the system. Sorry for bad english

Upvotes: 2

Views: 665

Answers (1)

Rahul Tripathi
Rahul Tripathi

Reputation: 172438

Event schedulers were introduced from MySQL 5.1 onwards. For older version you have to use the schedulers of your OS like cron in Unix or WindowsScheduler to schedule an event in MySQL.

Upvotes: 3

Related Questions