List:Commits« Previous MessageNext Message »
From:paul Date:January 26 2006 3:59pm
Subject:svn commit - mysqldoc@docsrva: r1044 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
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.1paul26 Jan