List:Commits« Previous MessageNext Message »
From:jon Date:February 21 2008 12:19pm
Subject:svn commit - mysqldoc@docsrva: r9965 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0
View as plain text  
Author: jstephens
Date: 2008-02-21 13:19:41 +0100 (Thu, 21 Feb 2008)
New Revision: 9965

Log:

Split final form of CREATE TABLE from options for visibility

partition_options for CREATE|ALTER TABLE now includes PARTITION BY

(Thanks, Roland!)



Modified:
   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml
   trunk/refman-6.0/sql-syntax.xml


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2008-02-21 10:59:15 UTC (rev 9964)
+++ trunk/refman-4.1/sql-syntax.xml	2008-02-21 12:19:41 UTC (rev 9965)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 0; 785 bytes

@@ -1572,7 +1572,9 @@
 <programlisting>
 CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <replaceable>tbl_name</replaceable>
     { LIKE <replaceable>old_tbl_name</replaceable> | (LIKE <replaceable>old_tbl_name</replaceable>) }
+</programlisting>
 
+<programlisting>
 <replaceable>create_definition</replaceable>:
     <replaceable>col_name</replaceable> <replaceable>column_definition</replaceable>
   | [CONSTRAINT [<replaceable>symbol</replaceable>]] PRIMARY KEY [<replaceable>index_type</replaceable>] (<replaceable>index_col_name</replaceable>,...)


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2008-02-21 10:59:15 UTC (rev 9964)
+++ trunk/refman-5.0/sql-syntax.xml	2008-02-21 12:19:41 UTC (rev 9965)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 0; 785 bytes

@@ -1676,7 +1676,9 @@
 <programlisting>
 CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <replaceable>tbl_name</replaceable>
     { LIKE <replaceable>old_tbl_name</replaceable> | (LIKE <replaceable>old_tbl_name</replaceable>) }
+</programlisting>
 
+<programlisting>
 <replaceable>create_definition</replaceable>:
     <replaceable>col_name</replaceable> <replaceable>column_definition</replaceable>
   | [CONSTRAINT [<replaceable>symbol</replaceable>]] PRIMARY KEY [<replaceable>index_type</replaceable>] (<replaceable>index_col_name</replaceable>,...)


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2008-02-21 10:59:15 UTC (rev 9964)
+++ trunk/refman-5.1/sql-syntax.xml	2008-02-21 12:19:41 UTC (rev 9965)
Changed blocks: 4, Lines Added: 7, Lines Deleted: 4; 2284 bytes

@@ -446,7 +446,7 @@
   | [DEFAULT] CHARACTER SET <replaceable>charset_name</replaceable> [COLLATE <replaceable>collation_name</replaceable>]
   | DISCARD TABLESPACE
   | IMPORT TABLESPACE
-  | PARTITION BY <replaceable>partition_options</replaceable>
+  | <replaceable>partition_options</replaceable>
   | ADD PARTITION (<replaceable>partition_definition</replaceable>)
   | DROP PARTITION <replaceable>partition_names</replaceable>
   | COALESCE PARTITION <replaceable>number</replaceable>

@@ -2899,7 +2899,7 @@
 CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <replaceable>tbl_name</replaceable>
     [(<replaceable>create_definition</replaceable>,...)]
     [<replaceable>table_option</replaceable> ...]
-    [PARTITION BY <replaceable>partition_options</replaceable>]
+    [<replaceable>partition_options</replaceable>]
     <replaceable>select_statement</replaceable>
 </programlisting>
 

@@ -2910,7 +2910,9 @@
 <programlisting>
 CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <replaceable>tbl_name</replaceable>
     { LIKE <replaceable>old_tbl_name</replaceable> | (LIKE <replaceable>old_tbl_name</replaceable>) }
+</programlisting>
 
+<programlisting>
 <replaceable>create_definition</replaceable>:
     <replaceable>col_name</replaceable> <replaceable>column_definition</replaceable>
   | [CONSTRAINT [<replaceable>symbol</replaceable>]] PRIMARY KEY [<replaceable>index_type</replaceable>] (<replaceable>index_col_name</replaceable>,...)

@@ -3018,10 +3020,11 @@
   | UNION [=] (<replaceable>tbl_name</replaceable>[,<replaceable>tbl_name</replaceable>]...)
 
 <replaceable>partition_options</replaceable>:
-          [LINEAR] HASH(<replaceable>expr</replaceable>)
+    PARTITION BY
+        { [LINEAR] HASH(<replaceable>expr</replaceable>)
         | [LINEAR] KEY(<replaceable>column_list</replaceable>)
         | RANGE(<replaceable>expr</replaceable>)
-        | LIST(<replaceable>expr</replaceable>)
+        | LIST(<replaceable>expr</replaceable>) }
     [PARTITIONS <replaceable>num</replaceable>]
     [SUBPARTITION BY
           [LINEAR] HASH(<replaceable>expr</replaceable>)


Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml	2008-02-21 10:59:15 UTC (rev 9964)
+++ trunk/refman-6.0/sql-syntax.xml	2008-02-21 12:19:41 UTC (rev 9965)
Changed blocks: 4, Lines Added: 7, Lines Deleted: 4; 2284 bytes

@@ -439,7 +439,7 @@
   | [DEFAULT] CHARACTER SET <replaceable>charset_name</replaceable> [COLLATE <replaceable>collation_name</replaceable>]
   | DISCARD TABLESPACE
   | IMPORT TABLESPACE
-  | PARTITION BY <replaceable>partition_options</replaceable>
+  | <replaceable>partition_options</replaceable>
   | ADD PARTITION (<replaceable>partition_definition</replaceable>)
   | DROP PARTITION <replaceable>partition_names</replaceable>
   | COALESCE PARTITION <replaceable>number</replaceable>

@@ -2832,7 +2832,7 @@
 CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <replaceable>tbl_name</replaceable>
     [(<replaceable>create_definition</replaceable>,...)]
     [<replaceable>table_option</replaceable> ...]
-    [PARTITION BY <replaceable>partition_options</replaceable>]
+    [<replaceable>partition_options</replaceable>]
     <replaceable>select_statement</replaceable>
 </programlisting>
 

@@ -2843,7 +2843,9 @@
 <programlisting>
 CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <replaceable>tbl_name</replaceable>
     { LIKE <replaceable>old_tbl_name</replaceable> | (LIKE <replaceable>old_tbl_name</replaceable>) }
+</programlisting>
 
+<programlisting>
 <replaceable>create_definition</replaceable>:
     <replaceable>col_name</replaceable> <replaceable>column_definition</replaceable>
   | [CONSTRAINT [<replaceable>symbol</replaceable>]] PRIMARY KEY [<replaceable>index_type</replaceable>] (<replaceable>index_col_name</replaceable>,...)

@@ -2952,10 +2954,11 @@
   | UNION [=] (<replaceable>tbl_name</replaceable>[,<replaceable>tbl_name</replaceable>]...)
 
 <replaceable>partition_options</replaceable>:
-          [LINEAR] HASH(<replaceable>expr</replaceable>)
+    PARTITION BY
+        { [LINEAR] HASH(<replaceable>expr</replaceable>)
         | [LINEAR] KEY(<replaceable>column_list</replaceable>)
         | RANGE(<replaceable>expr</replaceable>)
-        | LIST(<replaceable>expr</replaceable>)
+        | LIST(<replaceable>expr</replaceable>) }
     [PARTITIONS <replaceable>num</replaceable>]
     [SUBPARTITION BY
           [LINEAR] HASH(<replaceable>expr</replaceable>)


Thread
svn commit - mysqldoc@docsrva: r9965 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0jon21 Feb