How to create event for select statement

PHP
21

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 ?

22

Had you read the manual found at http://dev.mysql.com/doc/refman/5.1/en/create-event.html, 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.