From: paul
Date: May 18 2006 8:20pm
Subject: svn commit - mysqldoc@docsrva: r2123 - in trunk: . refman-4.1 refman-5.0 refman-5.1
List-Archive: http://lists.mysql.com/commits/6595
Message-Id: <200605182020.k4IKKHv0022351@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: paul
Date: 2006-05-18 22:20:15 +0200 (Thu, 18 May 2006)
New Revision: 2123
Log:
r7606@polar: paul | 2006-05-18 14:14:22 -0500
Slight reorganization of CREATE INDEX material.
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
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7586
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10508
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7606
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10508
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2006-05-18 13:39:09 UTC (rev 2122)
+++ trunk/refman-4.1/sql-syntax.xml 2006-05-18 20:20:15 UTC (rev 2123)
@@ -1137,6 +1137,24 @@
+ FULLTEXT indexes are supported only for
+ MyISAM tables and can include only
+ CHAR, VARCHAR, and
+ TEXT columns. FULLTEXT
+ indexes are available in MySQL 3.23.23 or later. See
+ .
+
+
+
+ SPATIAL indexes are supported only for
+ MyISAM tables and can include only spatial
+ columns that are defined as NOT NULL.
+ SPATIAL indexes are available in MySQL 4.1 or
+ later. , describes the
+ spatial data types.
+
+
+
You can add an index on a column that can have
NULL values only if you are using MySQL
3.23.2 or newer and are using the MyISAM,
@@ -1210,11 +1228,7 @@
be used as a synonym for USING
type_name to specify an
index type. However, USING is the preferred
- form. In addition, the index name that precedes the index type
- in the index specification syntax is not optional with
- TYPE: Unlike USING,
- TYPE is not a reserved word and is
- interpreted as the index name if no name is given.
+ form.
@@ -1224,33 +1238,6 @@
uses the available type.
-
- FULLTEXT indexes can include only
- CHAR, VARCHAR, and
- TEXT columns, and only in
- MyISAM tables. FULLTEXT
- indexes are available in MySQL 3.23.23 or later.
- .
-
-
-
- FULLTEXT indexes are supported only for
- MyISAM tables and can include only
- CHAR, VARCHAR, and
- TEXT columns. FULLTEXT
- indexes are available in MySQL 3.23.23 or later. See
- .
-
-
-
- SPATIAL indexes are supported only for
- MyISAM tables and can include only spatial
- columns that are defined as NOT NULL.
- SPATIAL indexes are available in MySQL 4.1 or
- later. , describes the
- spatial data types.
-
-
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-05-18 13:39:09 UTC (rev 2122)
+++ trunk/refman-5.0/sql-syntax.xml 2006-05-18 20:20:15 UTC (rev 2123)
@@ -1165,6 +1165,22 @@
+ FULLTEXT indexes are supported only for
+ MyISAM tables and can include only
+ CHAR, VARCHAR, and
+ TEXT columns. See
+ .
+
+
+
+ SPATIAL indexes are supported only for
+ MyISAM tables and can include only spatial
+ columns that are defined as NOT NULL.
+ , describes the spatial data
+ types.
+
+
+
In MySQL ¤t-series;:
@@ -1251,11 +1267,7 @@
be used as a synonym for USING
type_name to specify an
index type. However, USING is the preferred
- form. In addition, the index name that precedes the index type
- in the index specification syntax is not optional with
- TYPE: Unlike USING,
- TYPE is not a reserved word and is
- interpreted as the index name if no name is given.
+ form.
@@ -1265,22 +1277,6 @@
uses the available type.
-
- FULLTEXT indexes are supported only for
- MyISAM tables and can include only
- CHAR, VARCHAR, and
- TEXT columns. See
- .
-
-
-
- SPATIAL indexes are supported only for
- MyISAM tables and can include only spatial
- columns that are defined as NOT NULL.
- , describes the spatial data
- types.
-
-
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-05-18 13:39:09 UTC (rev 2122)
+++ trunk/refman-5.1/sql-syntax.xml 2006-05-18 20:20:15 UTC (rev 2123)
@@ -1630,6 +1630,22 @@
+ FULLTEXT indexes are supported only for
+ MyISAM tables and can include only
+ CHAR, VARCHAR, and
+ TEXT columns. See
+ .
+
+
+
+ SPATIAL indexes are supported only for
+ MyISAM tables and can include only spatial
+ columns that are defined as NOT NULL.
+ , describes the spatial data
+ types.
+
+
+
In MySQL ¤t-series;:
@@ -1716,11 +1732,7 @@
be used as a synonym for USING
type_name to specify an
index type. However, USING is the preferred
- form. In addition, the index name that precedes the index type
- in the index specification syntax is not optional with
- TYPE: Unlike USING,
- TYPE is not a reserved word and is
- interpreted as the index name if no name is given.
+ form.
@@ -1731,26 +1743,13 @@
- FULLTEXT indexes are supported only for
- MyISAM tables and can include only
- CHAR, VARCHAR, and
- TEXT columns. See
- . A WITH
+ For FULLTEXT indexes, a WITH
PARSER clause can be specified to associate a parser
plugin with the index if full-text indexing and searching
- operations need special handling. This clause is legal only for
- FULLTEXT indexes. See
+ operations need special handling. See
, for details on creating plugins.
-
- SPATIAL indexes are supported only for
- MyISAM tables and can include only spatial
- columns that are defined as NOT NULL.
- , describes the spatial data
- types.
-
-