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>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1700 - trunk/refman-5.1 | jon | 30 Mar |
