svn commit - mysqldoc@docsrva: r3887 - in trunk: refman-5.0 refman-5.1

[jon]

Author: jstephens
Date: 2006-11-09 04:18:32 +0100 (Thu, 09 Nov 2006)
New Revision: 3887

Log:

Fix for Docs Bug #24047



Modified:
   trunk/refman-5.0/faqs.xml
   trunk/refman-5.0/triggers.xml
   trunk/refman-5.1/faqs.xml
   trunk/refman-5.1/triggers.xml


Modified: trunk/refman-5.0/faqs.xml
===================================================================
--- trunk/refman-5.0/faqs.xml	2006-11-08 20:09:39 UTC (rev 3886)
+++ trunk/refman-5.0/faqs.xml	2006-11-09 03:18:32 UTC (rev 3887)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 6; 1421 bytes

@@ -67,8 +67,8 @@
         <question>
 
           <para>
-            Can MySQL &current-series; do multi-table inserts and
-            updates?
+            Can MySQL &current-series; peform multi-table inserts,
+            updates, and deletes?
           </para>
 
         </question>

@@ -76,11 +76,18 @@
         <answer>
 
           <para>
-            Yes. Multi-table <literal>UPDATE</literal> and
-            <literal>DELETE</literal> were actually implemented in MySQL
-            4.0, with enhancements added in MySQL 4.1. See
-            <xref linkend="update"/>, and <xref linkend="delete"/>.
+            Yes. For the syntax required to perform multi-table updates,
+            see <xref linkend="update"/>; for that required to perform
+            multi-table deletes, see <xref linkend="delete"/>.
           </para>
+          
+          <para>
+            A multi-table insert can be accomplished using a trigger
+            whose <literal>FOR EACH ROW</literal> clause contains
+            multiple <literal>INSERT</literal> statements within a
+            <literal>BEGIN ... END</literal> block. See  
+            <xref linkend="using-triggers"/>.
+          </para>
 
         </answer>
 


Modified: trunk/refman-5.0/triggers.xml
===================================================================
--- trunk/refman-5.0/triggers.xml	2006-11-08 20:09:39 UTC (rev 3886)
+++ trunk/refman-5.0/triggers.xml	2006-11-09 03:18:32 UTC (rev 3887)
Changed blocks: 2, Lines Added: 6, Lines Deleted: 1; 852 bytes

@@ -759,6 +759,11 @@
       extensions to triggers.
     </para>
 
+    <remark role="todo">
+      [js] Add an example demonstrating a multi-table insert, since we
+      now link to this section from a FAQ question concerning these.
+    </remark>
+
     <para>
       By using the <literal>BEGIN ... END</literal> construct, you can
       define a trigger that executes multiple statements. Within the

@@ -799,7 +804,7 @@
     </para>
 
     <remark role="todo">
-      [MH] Lets get an example of this created when we have time.
+      [MH] Let's get an example of this created when we have time.
     </remark>
 
     <para>


Modified: trunk/refman-5.1/faqs.xml
===================================================================
--- trunk/refman-5.1/faqs.xml	2006-11-08 20:09:39 UTC (rev 3886)
+++ trunk/refman-5.1/faqs.xml	2006-11-09 03:18:32 UTC (rev 3887)
Changed blocks: 2, Lines Added: 13, Lines Deleted: 6; 1421 bytes

@@ -67,8 +67,8 @@
         <question>
 
           <para>
-            Can MySQL &current-series; do multi-table inserts and
-            updates?
+            Can MySQL &current-series; peform multi-table inserts,
+            updates, and deletes?
           </para>
 
         </question>

@@ -76,11 +76,18 @@
         <answer>
 
           <para>
-            Yes. Multi-table <literal>UPDATE</literal> and
-            <literal>DELETE</literal> were actually implemented in MySQL
-            4.0, with enhancements added in MySQL 4.1. See
-            <xref linkend="update"/>, and <xref linkend="delete"/>.
+            Yes. For the syntax required to perform multi-table updates,
+            see <xref linkend="update"/>; for that required to perform
+            multi-table deletes, see <xref linkend="delete"/>.
           </para>
+          
+          <para>
+            A multi-table insert can be accomplished using a trigger
+            whose <literal>FOR EACH ROW</literal> clause contains
+            multiple <literal>INSERT</literal> statements within a
+            <literal>BEGIN ... END</literal> block. See  
+            <xref linkend="using-triggers"/>.
+          </para>
 
         </answer>
 


Modified: trunk/refman-5.1/triggers.xml
===================================================================
--- trunk/refman-5.1/triggers.xml	2006-11-08 20:09:39 UTC (rev 3886)
+++ trunk/refman-5.1/triggers.xml	2006-11-09 03:18:32 UTC (rev 3887)
Changed blocks: 2, Lines Added: 6, Lines Deleted: 1; 852 bytes

@@ -712,6 +712,11 @@
       extensions to triggers.
     </para>
 
+    <remark role="todo">
+      [js] Add an example demonstrating a multi-table insert, since we
+      now link to this section from a FAQ question concerning these.
+    </remark>
+
     <para>
       By using the <literal>BEGIN ... END</literal> construct, you can
       define a trigger that executes multiple statements. Within the

@@ -752,7 +757,7 @@
     </para>
 
     <remark role="todo">
-      [MH] Lets get an example of this created when we have time.
+      [MH] Let's get an example of this created when we have time.
     </remark>
 
     <para>