From: paul Date: December 13 2005 6:10pm Subject: svn commit - mysqldoc@docsrva: r552 - in trunk: . refman-4.1 refman-5.0 List-Archive: http://lists.mysql.com/commits/121 Message-Id: <200512131810.jBDIAcfX029028@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: paul Date: 2005-12-13 19:10:37 +0100 (Tue, 13 Dec 2005) New Revision: 552 Log: r4742@frost: paul | 2005-12-13 09:24:44 -0600 Update syntax. Modified: trunk/ trunk/refman-4.1/sql-syntax.xml trunk/refman-5.0/sql-syntax.xml Property changes on: trunk ___________________________________________________________________ Name: svk:merge - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4737 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1609 + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4742 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1609 Modified: trunk/refman-4.1/sql-syntax.xml =================================================================== --- trunk/refman-4.1/sql-syntax.xml 2005-12-13 16:59:41 UTC (rev 551) +++ trunk/refman-4.1/sql-syntax.xml 2005-12-13 18:10:37 UTC (rev 552) @@ -131,8 +131,8 @@ | ADD [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name,...) | ADD [CONSTRAINT [symbol]] - UNIQUE [index_name] [index_type] (index_col_name,...) - | ADD [FULLTEXT|SPATIAL] [index_name] (index_col_name,...) + UNIQUE [INDEX] [index_name] [index_type] (index_col_name,...) + | ADD [FULLTEXT|SPATIAL] [INDEX] [index_name] (index_col_name,...) | ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition] @@ -1170,7 +1170,7 @@ - FULLTEXT indexes can index only + FULLTEXT indexes can include only CHAR, VARCHAR, and TEXT columns, and only in MyISAM tables. FULLTEXT @@ -1179,7 +1179,7 @@ - SPATIAL indexes can index only spatial + SPATIAL indexes can include only spatial columns, and only in MyISAM tables. SPATIAL indexes are available in MySQL 4.1 or later. Spatial column types are described in Modified: trunk/refman-5.0/sql-syntax.xml =================================================================== --- trunk/refman-5.0/sql-syntax.xml 2005-12-13 16:59:41 UTC (rev 551) +++ trunk/refman-5.0/sql-syntax.xml 2005-12-13 18:10:37 UTC (rev 552) @@ -139,8 +139,8 @@ | ADD [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name,...) | ADD [CONSTRAINT [symbol]] - UNIQUE [index_name] [index_type] (index_col_name,...) - | ADD [FULLTEXT|SPATIAL] [index_name] (index_col_name,...) + UNIQUE [INDEX] [index_name] [index_type] (index_col_name,...) + | ADD [FULLTEXT|SPATIAL] [INDEX] [index_name] (index_col_name,...) | ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition] @@ -1189,7 +1189,7 @@ - FULLTEXT indexes can index only + FULLTEXT indexes can include only CHAR, VARCHAR, and TEXT columns, and only in MyISAM tables. See @@ -1197,7 +1197,7 @@ - SPATIAL indexes can index only spatial + SPATIAL indexes can include only spatial columns, and only in MyISAM tables. Spatial column types are described in .