From: jon
Date: April 1 2006 11:08am
Subject: svn commit - mysqldoc@docsrva: r1715 - trunk/refman-5.1
List-Archive: http://lists.mysql.com/commits/4393
Message-Id: <200604011108.k31B8r4b021838@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2006-04-01 13:08:53 +0200 (Sat, 01 Apr 2006)
New Revision: 1715

Log:

Events: Added some missing lines/clauses in examples

Fix for Bug #18637 (Server:Docs)



Modified:
   trunk/refman-5.1/events.xml

Modified: trunk/refman-5.1/events.xml
===================================================================
--- trunk/refman-5.1/events.xml	2006-04-01 10:02:42 UTC (rev 1714)
+++ trunk/refman-5.1/events.xml	2006-04-01 11:08:53 UTC (rev 1715)
@@ -678,7 +678,8 @@
 
 <programlisting>
 CREATE EVENT e_hourly
-    EVERY 1 HOUR
+    ON SCHEDULE 
+      EVERY 1 HOUR
     COMMENT 'Clears out sessions table each hour.'
     DO
       DELETE FROM site_activity.sessions;
@@ -712,7 +713,8 @@
 DELIMITER |
 
 CREATE EVENT e_daily
-    EVERY 1 DAY
+    ON SCHEDULE
+      EVERY 1 DAY
     COMMENT 'Saves total number of sessions then clears the table each day.'
     DO
       BEGIN
@@ -741,7 +743,8 @@
 DELIMITER |
 
 CREATE EVENT e
-    ON SCHEDULE EVERY 5 SECOND
+    ON SCHEDULE 
+      EVERY 5 SECOND
     DO
       BEGIN
         DECLARE v INTEGER;
@@ -767,7 +770,8 @@
 
 <programlisting>
 CREATE EVENT e_call_myproc
-    ON SCHEDULE AT CURRENT_TIMESTAMP + 1 DAY
+    ON SCHEDULE 
+      AT CURRENT_TIMESTAMP + 1 DAY
     DO CALL myproc(5, 27); 
 </programlisting>
 
@@ -821,7 +825,8 @@
 
 <programlisting>
 mysql&gt; <userinput>ALTER EVENT no_such_event </userinput>
-     &gt;     <userinput>ON SCHEDULE EVERY '2:3' DAY_HOUR;</userinput>
+     &gt;     <userinput>ON SCHEDULE </userinput>
+     &gt;       <userinput>EVERY '2:3' DAY_HOUR;</userinput>
 <errortext>ERROR 1517 (HY000): Unknown event 'no_such_event'</errortext>
 </programlisting>
 
@@ -832,7 +837,8 @@
 
 <programlisting>
 CREATE EVENT myevent
-    ON SCHEDULE EVERY 6 HOUR
+    ON SCHEDULE 
+      EVERY 6 HOUR
     COMMENT 'A sample comment.'
     DO
       UPDATE myschema.mytable SET mycol = mycol + 1;
@@ -847,7 +853,9 @@
 
 <programlisting>
 ALTER EVENT myevent
-    ON SCHEDULE EVERY 12 HOUR STARTS CURRENT_TIMESTAMP + 4 HOUR;
+    ON SCHEDULE 
+      EVERY 12 HOUR 
+    STARTS CURRENT_TIMESTAMP + 4 HOUR;
 </programlisting>
 
       <para>
@@ -871,7 +879,8 @@
 
 <programlisting>
 ALTER TABLE myevent
-    ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
+    ON SCHEDULE 
+      AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
     DO
       TRUNCATE TABLE myschema.mytable;
 </programlisting>
@@ -1054,8 +1063,10 @@
 
 <programlisting>
 CREATE EVENT e_store_ts
-    ON SCHEDULE EVERY 10 SECOND
-    DO INSERT INTO myschema.mytable VALUES (UNIX_TIMESTAMP());
+    ON SCHEDULE 
+      EVERY 10 SECOND
+    DO 
+      INSERT INTO myschema.mytable VALUES (UNIX_TIMESTAMP());
 </programlisting>
 
     <para>
@@ -1157,8 +1168,10 @@
 
 <programlisting>
 CREATE EVENT e_insert
-    ON SCHEDULE EVERY 7 SECOND
-    SO INSERT INTO myschema.mytable;
+    ON SCHEDULE 
+      EVERY 7 SECOND
+    DO 
+      INSERT INTO myschema.mytable;
 </programlisting>
 
     <para>