From: jon
Date: March 30 2006 3:57am
Subject: svn commit - mysqldoc@docsrva: r1700 - trunk/refman-5.1
List-Archive: http://lists.mysql.com/commits/4302
Message-Id: <200603300357.k2U3vJ17032299@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2006-03-30 05:57:18 +0200 (Thu, 30 Mar 2006)
New Revision: 1700

Log:

TRUNCATE does not invoke ON DELETE triggers (user suggested).



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

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-03-29 10:59:44 UTC (rev 1699)
+++ trunk/refman-5.1/sql-syntax.xml	2006-03-30 03:57:18 UTC (rev 1700)
@@ -10471,6 +10471,13 @@
             Truncate operations drop and re-create the table, which is
             much faster than deleting rows one by one.
           </para>
+          
+          <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>
         </listitem>
 
         <listitem>

Modified: trunk/refman-5.1/triggers.xml
===================================================================
--- trunk/refman-5.1/triggers.xml	2006-03-29 10:59:44 UTC (rev 1699)
+++ trunk/refman-5.1/triggers.xml	2006-03-30 03:57:18 UTC (rev 1700)
@@ -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>