From: jon
Date: March 30 2006 4:33am
Subject: svn commit - mysqldoc@docsrva: r1702 - trunk/refman-5.0
List-Archive: http://lists.mysql.com/commits/4305
Message-Id: <200603300433.k2U4XvOR008687@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2006-03-30 06:33:55 +0200 (Thu, 30 Mar 2006)
New Revision: 1702

Log:

Ummmm... We have triggers in 5.0 as well... (Thanks, Paul!)



Modified:
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.0/triggers.xml

Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-03-30 04:03:17 UTC (rev 1701)
+++ trunk/refman-5.0/sql-syntax.xml	2006-03-30 04:33:55 UTC (rev 1702)
@@ -9317,6 +9317,13 @@
         </listitem>
 
       </itemizedlist>
+      
+      <para>
+        Since truncation of a table does not make any use of
+        <literal>DELETE</literal>, the <literal>TRUNCATE</literal>
+        statement does not invoke <literal>ON DELETE</literal>
+        triggers.
+      </para>
 
       <para>
         <literal>TRUNCATE TABLE</literal> is an Oracle SQL extension

Modified: trunk/refman-5.0/triggers.xml
===================================================================
--- trunk/refman-5.0/triggers.xml	2006-03-30 04:03:17 UTC (rev 1701)
+++ trunk/refman-5.0/triggers.xml	2006-03-30 04:33:55 UTC (rev 1702)
@@ -139,7 +139,9 @@
           <literal>DELETE</literal>: The trigger is activated whenever a
           row is deleted from the table; for example, through
           <literal>DELETE</literal> and <literal>REPLACE</literal>
-          statements.
+          statements. However, a <literal>TRUNCATE</literal> statement
+          on the table does <emphasis>not</emphasis> invoke this
+          trigger. See <xref linkend="truncate"/>.
         </para>
       </listitem>