Friday, September 13, 2013

how to create mysql scheduler event example


It is important to understand that an event is executed with the privileges of its definer, and that it cannot 
perform any actions for which its definer does not have the requisite privileges. For example, suppose that 
 has the EVENT privilege for myschema. Suppose also that this user has the
 SELECT privilege for myschema, but no other privileges for this schema. It is possible
 to create a new event such as this one:
example : 

CREATE EVENT new_event_by_bikash
ON SCHEDULE
EVERY 11 SECOND
DO
      INSERT INTO books(title) VALUES ('author bikash');

No comments:

Post a Comment