Author: paul
Date: 2006-01-26 16:59:05 +0100 (Thu, 26 Jan 2006)
New Revision: 1044
Log:
r2543@kite-hub: paul | 2006-01-26 09:55:35 -0600
BINARY/VARBINARY can have index prefixes, too.
Modified:
trunk/
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6690
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2542
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6690
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2543
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2006-01-26 15:58:45 UTC (rev 1043)
+++ trunk/refman-4.1/sql-syntax.xml 2006-01-26 15:59:05 UTC (rev 1044)
@@ -1034,13 +1034,18 @@
</para>
<para>
- For <literal>CHAR</literal> and <literal>VARCHAR</literal>
+ For <literal>CHAR</literal>, <literal>VARCHAR</literal>
+ <literal>BINARY</literal>, and <literal>VARBINARY</literal>
columns, indexes can be created that use only part of a column,
using
<literal><replaceable>col_name</replaceable>(<replaceable>length</replaceable>)</literal>
- syntax to index a prefix consisting of the first
- <replaceable>length</replaceable> characters of each column
- value. <literal>BLOB</literal> and <literal>TEXT</literal>
+ syntax to specify an index prefix length. Index entries consist
+ of the first <replaceable>length</replaceable> characters of
+ each column value for <literal>CHAR</literal> and
+ <literal>VARCHAR</literal> columns, and the first
+ <replaceable>length</replaceable> bytes of each column value for
+ <literal>BINARY</literal> and <literal>VARBINARY</literal>
+ columns. <literal>BLOB</literal> and <literal>TEXT</literal>
columns also can be indexed, but a prefix length
<emphasis>must</emphasis> be given.
</para>
@@ -1749,10 +1754,14 @@
With
<literal><replaceable>col_name</replaceable>(<replaceable>length</replaceable>)</literal>
syntax in an index specification, you can create an index
- that uses only the first <replaceable>length</replaceable>
- characters of a <literal>CHAR</literal> or
- <literal>VARCHAR</literal> column. Indexing only a prefix of
- column values like this can make the index file much
+ that uses only part of a column. Index entries consist of
+ the first <replaceable>length</replaceable> characters of
+ each column value for <literal>CHAR</literal> and
+ <literal>VARCHAR</literal> columns, and the first
+ <replaceable>length</replaceable> bytes of each column value
+ for <literal>BINARY</literal> and
+ <literal>VARBINARY</literal> columns. Indexing only a prefix
+ of column values like this can make the index file much
smaller. See <xref linkend="indexes"/>.
</para>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-01-26 15:58:45 UTC (rev 1043)
+++ trunk/refman-5.0/sql-syntax.xml 2006-01-26 15:59:05 UTC (rev 1044)
@@ -1066,13 +1066,18 @@
</para>
<para>
- For <literal>CHAR</literal> and <literal>VARCHAR</literal>
+ For <literal>CHAR</literal>, <literal>VARCHAR</literal>
+ <literal>BINARY</literal>, and <literal>VARBINARY</literal>
columns, indexes can be created that use only part of a column,
using
<literal><replaceable>col_name</replaceable>(<replaceable>length</replaceable>)</literal>
- syntax to index a prefix consisting of the first
- <replaceable>length</replaceable> characters of each column
- value. <literal>BLOB</literal> and <literal>TEXT</literal>
+ syntax to specify an index prefix length. Index entries consist
+ of the first <replaceable>length</replaceable> characters of
+ each column value for <literal>CHAR</literal> and
+ <literal>VARCHAR</literal> columns, and the first
+ <replaceable>length</replaceable> bytes of each column value for
+ <literal>BINARY</literal> and <literal>VARBINARY</literal>
+ columns. <literal>BLOB</literal> and <literal>TEXT</literal>
columns also can be indexed, but a prefix length
<emphasis>must</emphasis> be given.
</para>
@@ -1788,10 +1793,14 @@
With
<literal><replaceable>col_name</replaceable>(<replaceable>length</replaceable>)</literal>
syntax in an index specification, you can create an index
- that uses only the first <replaceable>length</replaceable>
- characters of a <literal>CHAR</literal> or
- <literal>VARCHAR</literal> column. Indexing only a prefix of
- column values like this can make the index file much
+ that uses only part of a column. Index entries consist of
+ the first <replaceable>length</replaceable> characters of
+ each column value for <literal>CHAR</literal> and
+ <literal>VARCHAR</literal> columns, and the first
+ <replaceable>length</replaceable> bytes of each column value
+ for <literal>BINARY</literal> and
+ <literal>VARBINARY</literal> columns. Indexing only a prefix
+ of column values like this can make the index file much
smaller. See <xref linkend="indexes"/>.
</para>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-01-26 15:58:45 UTC (rev 1043)
+++ trunk/refman-5.1/sql-syntax.xml 2006-01-26 15:59:05 UTC (rev 1044)
@@ -1276,13 +1276,18 @@
</para>
<para>
- For <literal>CHAR</literal> and <literal>VARCHAR</literal>
+ For <literal>CHAR</literal>, <literal>VARCHAR</literal>
+ <literal>BINARY</literal>, and <literal>VARBINARY</literal>
columns, indexes can be created that use only part of a column,
using
<literal><replaceable>col_name</replaceable>(<replaceable>length</replaceable>)</literal>
- syntax to index a prefix consisting of the first
- <replaceable>length</replaceable> characters of each column
- value. <literal>BLOB</literal> and <literal>TEXT</literal>
+ syntax to specify an index prefix length. Index entries consist
+ of the first <replaceable>length</replaceable> characters of
+ each column value for <literal>CHAR</literal> and
+ <literal>VARCHAR</literal> columns, and the first
+ <replaceable>length</replaceable> bytes of each column value for
+ <literal>BINARY</literal> and <literal>VARBINARY</literal>
+ columns. <literal>BLOB</literal> and <literal>TEXT</literal>
columns also can be indexed, but a prefix length
<emphasis>must</emphasis> be given.
</para>
@@ -2044,10 +2049,14 @@
With
<literal><replaceable>col_name</replaceable>(<replaceable>length</replaceable>)</literal>
syntax in an index specification, you can create an index
- that uses only the first <replaceable>length</replaceable>
- characters of a <literal>CHAR</literal> or
- <literal>VARCHAR</literal> column. Indexing only a prefix of
- column values like this can make the index file much
+ that uses only part of a column. Index entries consist of
+ the first <replaceable>length</replaceable> characters of
+ each column value for <literal>CHAR</literal> and
+ <literal>VARCHAR</literal> columns, and the first
+ <replaceable>length</replaceable> bytes of each column value
+ for <literal>BINARY</literal> and
+ <literal>VARBINARY</literal> columns. Indexing only a prefix
+ of column values like this can make the index file much
smaller. See <xref linkend="indexes"/>.
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1044 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 26 Jan |
