<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="events-syntax">
      </a>
      27.4.3 Event Syntax
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045082113936">
  </a>
  <p>
   MySQL provides several SQL statements for working with scheduled
      events:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      New events are defined using the
      <a class="link" href="create-event.html" title="15.1.13 CREATE EVENT Statement">
       <code class="literal">
        CREATE
          EVENT
       </code>
      </a>
      statement. See
      <a class="xref" href="create-event.html" title="15.1.13 CREATE EVENT Statement">
       Section 15.1.13, “CREATE EVENT Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The definition of an existing event can be changed by means of
          the
      <a class="link" href="alter-event.html" title="15.1.3 ALTER EVENT Statement">
       <code class="literal">
        ALTER EVENT
       </code>
      </a>
      statement. See
      <a class="xref" href="alter-event.html" title="15.1.3 ALTER EVENT Statement">
       Section 15.1.3, “ALTER EVENT Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      When a scheduled event is no longer wanted or needed, it can
          be deleted from the server by its definer using the
      <a class="link" href="drop-event.html" title="15.1.25 DROP EVENT Statement">
       <code class="literal">
        DROP EVENT
       </code>
      </a>
      statement. See
      <a class="xref" href="drop-event.html" title="15.1.25 DROP EVENT Statement">
       Section 15.1.25, “DROP EVENT Statement”
      </a>
      . Whether an event persists past
          the end of its schedule also depends on its
      <code class="literal">
       ON
          COMPLETION
      </code>
      clause, if it has one. See
      <a class="xref" href="create-event.html" title="15.1.13 CREATE EVENT Statement">
       Section 15.1.13, “CREATE EVENT Statement”
      </a>
      .
     </p>
     <p>
      An event can be dropped by any user having the
      <a class="link" href="privileges-provided.html#priv_event">
       <code class="literal">
        EVENT
       </code>
      </a>
      privilege for the
          database on which the event is defined. See
      <a class="xref" href="events-privileges.html" title="27.4.6 The Event Scheduler and MySQL Privileges">
       Section 27.4.6, “The Event Scheduler and MySQL Privileges”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
