Author: jstephens
Date: 2006-02-16 09:38:47 +0100 (Thu, 16 Feb 2006)
New Revision: 1343
Log:
Events and triggers are not routines. They're objects. (PeterG)
Modified:
trunk/refman-5.1/events.xml
Modified: trunk/refman-5.1/events.xml
===================================================================
--- trunk/refman-5.1/events.xml 2006-02-15 23:37:15 UTC (rev 1342)
+++ trunk/refman-5.1/events.xml 2006-02-16 08:38:47 UTC (rev 1343)
@@ -99,26 +99,27 @@
MySQL Events are tasks that run according to a schedule.
Therefore, we sometimes refer to them as
<emphasis>scheduled</emphasis> events. When you create an event,
- you are creating a named routine consisting of one or more SQL
- statements, which is to be executed at one or more regular
- intervals, beginning and ending at a specific date and time.
- Conceptually, this is similar to the idea of the Unix
- <literal>crontab</literal> (also known as a <quote>cron
- job</quote>) or the Windows Task Scheduler.
+ you are creating a named database object containing one or more
+ SQL statements to be executed at one or more regular intervals,
+ beginning and ending at a specific date and time. Conceptually,
+ this is similar to the idea of the Unix <literal>crontab</literal>
+ (also known as a <quote>cron job</quote>) or the Windows Task
+ Scheduler.
</para>
<para>
Scheduled tasks of this type are also sometimes known as
- <quote>temporal triggers</quote>, implying that these are routines
+ <quote>temporal triggers</quote>, implying that these are objects
that are triggered by the passage of time. While this is
essentially correct, we prefer to use the term
<emphasis>events</emphasis> in order to avoid confusion with
triggers of the type discussed in <xref linkend="triggers"/>.
Events should more specifically not be confused with
- <quote>temporary triggers</quote>. Whereas a trigger is a routine
- that is executed in response to a specific type of event that
- occurs on a given table, a (scheduled) event is a routine that is
- executed in response to the passage of a specified time interval.
+ <quote>temporary triggers</quote>. Whereas a trigger is a database
+ object whose statements are executed in response to a specific
+ type of event that occurs on a given table, a (scheduled) event is
+ an object whose statements are executed in response to the passage
+ of a specified time interval.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1343 - trunk/refman-5.1 | jon | 16 Feb |