Sebastian Hoitz
Sebastian Hoitz

Reputation: 9383

MySQL call a stored procedure every x minutes

Is there a way in MySQL to call a stored procedure from within SQL every x minutes?

I want to use this in a session-environment, where the database keeps track of all the sessions and automatically deletes sessions older than x minutes.

Upvotes: 2

Views: 557

Answers (1)

Ben S
Ben S

Reputation: 69342

Use MySQL Events, it was introduced in version 5.1.

Upvotes: 3

Related Questions