Author: mcbrown
Date: 2006-07-19 12:11:18 +0200 (Wed, 19 Jul 2006)
New Revision: 2771
Log:
Docs Bug #21106 (TRUNCATE, DROP on compressed tables)
Modified:
trunk/refman-4.1/storage-engines.xml
trunk/refman-5.0/storage-engines.xml
trunk/refman-5.1/storage-engines.xml
Modified: trunk/refman-4.1/storage-engines.xml
===================================================================
--- trunk/refman-4.1/storage-engines.xml 2006-07-19 09:38:23 UTC (rev 2770)
+++ trunk/refman-4.1/storage-engines.xml 2006-07-19 10:11:18 UTC (rev 2771)
Changed blocks: 2, Lines Added: 17, Lines Deleted: 1; 1141 bytes
@@ -1327,6 +1327,21 @@
</itemizedlist>
+ <formalpara>
+
+ <title>Note</title>
+
+ <para>
+ While a compressed table is read-only, and you cannot
+ therefore update or add rows in the table, DDL (Data
+ Definition Language) operations are still valid. For
+ example, you may still use <literal>DROP</literal> to drop
+ the table, and <literal>TRUNCATE</literal> to empty the
+ table.
+ </para>
+
+ </formalpara>
+
</section>
</section>
@@ -2430,7 +2445,8 @@
<section id="bdb-storage-engine">
- <title>The <literal>BDB</literal>
(<literal>BerkeleyDB</literal>) Storage Engine</title>
+ <title>The <literal>BDB</literal>
(<literal>BerkeleyDB</literal>) Storage
+ Engine</title>
<indexterm>
<primary><literal>BDB</literal> storage engine</primary>
Modified: trunk/refman-5.0/storage-engines.xml
===================================================================
--- trunk/refman-5.0/storage-engines.xml 2006-07-19 09:38:23 UTC (rev 2770)
+++ trunk/refman-5.0/storage-engines.xml 2006-07-19 10:11:18 UTC (rev 2771)
Changed blocks: 2, Lines Added: 17, Lines Deleted: 1; 1141 bytes
@@ -1336,6 +1336,21 @@
</itemizedlist>
+ <formalpara>
+
+ <title>Note</title>
+
+ <para>
+ While a compressed table is read-only, and you cannot
+ therefore update or add rows in the table, DDL (Data
+ Definition Language) operations are still valid. For
+ example, you may still use <literal>DROP</literal> to drop
+ the table, and <literal>TRUNCATE</literal> to empty the
+ table.
+ </para>
+
+ </formalpara>
+
</section>
</section>
@@ -2395,7 +2410,8 @@
<section id="bdb-storage-engine">
- <title>The <literal>BDB</literal>
(<literal>BerkeleyDB</literal>) Storage Engine</title>
+ <title>The <literal>BDB</literal>
(<literal>BerkeleyDB</literal>) Storage
+ Engine</title>
<indexterm>
<primary><literal>BDB</literal> storage engine</primary>
Modified: trunk/refman-5.1/storage-engines.xml
===================================================================
--- trunk/refman-5.1/storage-engines.xml 2006-07-19 09:38:23 UTC (rev 2770)
+++ trunk/refman-5.1/storage-engines.xml 2006-07-19 10:11:18 UTC (rev 2771)
Changed blocks: 3, Lines Added: 19, Lines Deleted: 3; 1597 bytes
@@ -1286,6 +1286,21 @@
</itemizedlist>
+ <formalpara>
+
+ <title>Note</title>
+
+ <para>
+ While a compressed table is read-only, and you cannot
+ therefore update or add rows in the table, DDL (Data
+ Definition Language) operations are still valid. For
+ example, you may still use <literal>DROP</literal> to drop
+ the table, and <literal>TRUNCATE</literal> to empty the
+ table.
+ </para>
+
+ </formalpara>
+
</section>
</section>
@@ -2340,7 +2355,8 @@
<section id="bdb-storage-engine">
- <title>The <literal>BDB</literal>
(<literal>BerkeleyDB</literal>) Storage Engine</title>
+ <title>The <literal>BDB</literal>
(<literal>BerkeleyDB</literal>) Storage
+ Engine</title>
<indexterm>
<primary><literal>BDB</literal> storage engine</primary>
@@ -3980,12 +3996,12 @@
This format can be read, and even written, by spreadsheet
applications such as Microsoft Excel or StarOffice Calc.
</para>
-
+
<para>
<emphasis role="bold">Important</emphasis>: The
<literal>CSV</literal> storage engine does not support indexing.
</para>
-
+
<para>
Partitioning is not supported for tables using the
<literal>CSV</literal> storage engine. Beginning with MySQL
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2771 - in trunk: refman-4.1 refman-5.0 refman-5.1 | mcbrown | 19 Jul |