How to create event for select statement

Thanks to your response

The event scheduler is working on insertion ,deletion…

Bur i want to know,

Does the event scheduler work on the select query or not ?

Had you read the manual found at, you’d notice that

Statements such as SELECT or SHOW that merely return a result set have no effect when used in an event; the output from these is not sent to the MySQL Monitor, nor is it stored anywhere. However, you can use statements such as SELECT … INTO and INSERT INTO … SELECT that store a result.