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.0 | jon | 21 Feb |
