svn commit - mysqldoc@docsrva: r6393 - trunk/refman-5.1

[jon]

Author: jstephens
Date: 2007-05-09 15:40:05 +0200 (Wed, 09 May 2007)
New Revision: 6393

Log:

Fixed missing INTERVAL keyword in a couple of examples (Horst)



Modified:
   trunk/refman-5.1/events.xml


Modified: trunk/refman-5.1/events.xml
===================================================================
--- trunk/refman-5.1/events.xml	2007-05-09 07:32:29 UTC (rev 6392)
+++ trunk/refman-5.1/events.xml	2007-05-09 13:40:05 UTC (rev 6393)
Changed blocks: 2, Lines Added: 5, Lines Deleted: 5; 1296 bytes

@@ -1062,10 +1062,10 @@
             one week from now</quote>. Similarly, you can express
             <quote>every two weeks, beginning six hours and fifteen
             minutes from now</quote> as <literal>EVERY 2 WEEK STARTS
-            CURRENT_TIMESTAMP + '6:15' HOUR_MINUTE</literal>. Not
-            specifying <literal>STARTS</literal> is the same as using
-            <literal>STARTS CURRENT_TIMESTAMP</literal> &mdash; that is,
-            the action specified for the event begins repeating
+            CURRENT_TIMESTAMP + INTERVAL '6:15' HOUR_MINUTE</literal>.
+            Not specifying <literal>STARTS</literal> is the same as
+            using <literal>STARTS CURRENT_TIMESTAMP</literal> &mdash;
+            that is, the action specified for the event begins repeating
             immediately upon creation of the event.
           </para>
 

@@ -1302,7 +1302,7 @@
 <programlisting>
 CREATE EVENT e_call_myproc
     ON SCHEDULE 
-      AT CURRENT_TIMESTAMP + 1 DAY
+      AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
     DO CALL myproc(5, 27); 
 </programlisting>