Author: jstephens
Date: 2006-02-14 16:09:29 +0100 (Tue, 14 Feb 2006)
New Revision: 1312
Log:
RefMan 5.0/5.1: Moved show-create-view to sql-syntax/show. (Stefan)
Modified:
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.0/views.xml
trunk/refman-5.1/sql-syntax.xml
trunk/refman-5.1/views.xml
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-02-14 14:37:57 UTC (rev 1311)
+++ trunk/refman-5.0/sql-syntax.xml 2006-02-14 15:09:29 UTC (rev 1312)
@@ -14606,6 +14606,10 @@
</indexterm>
<indexterm type="function">
+ <primary>SHOW CREATE VIEW</primary>
+ </indexterm>
+
+ <indexterm type="function">
<primary>SHOW DATABASES</primary>
</indexterm>
@@ -15154,6 +15158,58 @@
</section>
+ <section id="show-create-view">
+
+ <title>&title-show-create-view;</title>
+
+ <indexterm type="function">
+ <primary>SHOW CREATE VIEW</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW CREATE VIEW"/>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW CREATE VIEW <replaceable>view_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement shows a <literal>CREATE VIEW</literal> statement
+ that creates the given view.
+ </para>
+
+ <remark role="help-description-end"/>
+
+<programlisting>
+mysql> <userinput>SHOW CREATE VIEW v;</userinput>
++------+----------------------------------------------------+
+| View | Create View |
++------+----------------------------------------------------+
+| v | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
++------+----------------------------------------------------+
+</programlisting>
+
+ <para>
+ This statement was added in MySQL 5.0.1.
+ </para>
+
+ <para>
+ Prior to MySQL 5.0.11, the output columns from this statement were
+ shown as <literal>Table</literal> and <literal>Create
+ Table</literal>.
+ </para>
+
+ <para>
+ You can also obtain information about view objects from
+ <literal>INFORMATION_SCHEMA</literal>, which contains a
+ <literal>VIEWS</literal> table. See <xref linkend="views-table"/>.
+ </para>
+
+ </section>
+
<section id="show-databases">
<title>&title-show-databases;</title>
Modified: trunk/refman-5.0/views.xml
===================================================================
--- trunk/refman-5.0/views.xml 2006-02-14 14:37:57 UTC (rev 1311)
+++ trunk/refman-5.0/views.xml 2006-02-14 15:09:29 UTC (rev 1312)
@@ -44,13 +44,6 @@
</para>
</listitem>
- <listitem>
- <para>
- Displaying view metadata with <literal>SHOW CREATE
- VIEW</literal>
- </para>
- </listitem>
-
</itemizedlist>
<para>
@@ -64,6 +57,14 @@
the view-related privileges. See
<xref linkend="mysql-fix-privilege-tables"/>.
</para>
+
+ <para>
+ Metadata about views can be obtained from the
+ <literal>INFORMATION_SCHEMA.VIEWS</literal> table and by using the
+ <literal>SHOW CREATE VIEW</literal> statement. See
+ <xref linkend="views-table"/> and
+ <xref linkend="show-create-view"/>.
+ </para>
<section id="alter-view">
@@ -1047,56 +1048,4 @@
</section>
- <section id="show-create-view">
-
- <title>&title-show-create-view;</title>
-
- <indexterm type="function">
- <primary>SHOW CREATE VIEW</primary>
- </indexterm>
-
- <remark role="help-topic" condition="SHOW CREATE VIEW"/>
-
- <remark role="help-syntax"/>
-
-<programlisting>
-SHOW CREATE VIEW <replaceable>view_name</replaceable>
-</programlisting>
-
- <remark role="help-description-begin"/>
-
- <para>
- This statement shows a <literal>CREATE VIEW</literal> statement
- that creates the given view.
- </para>
-
- <remark role="help-description-end"/>
-
-<programlisting>
-mysql> <userinput>SHOW CREATE VIEW v;</userinput>
-+------+----------------------------------------------------+
-| View | Create View |
-+------+----------------------------------------------------+
-| v | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
-+------+----------------------------------------------------+
-</programlisting>
-
- <para>
- This statement was added in MySQL 5.0.1.
- </para>
-
- <para>
- Prior to MySQL 5.0.11, the output columns from this statement were
- shown as <literal>Table</literal> and <literal>Create
- Table</literal>.
- </para>
-
- <para>
- You can also obtain information about view objects from
- <literal>INFORMATION_SCHEMA</literal>, which contains a
- <literal>VIEWS</literal> table. See <xref linkend="views-table"/>.
- </para>
-
- </section>
-
</chapter>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-02-14 14:37:57 UTC (rev 1311)
+++ trunk/refman-5.1/sql-syntax.xml 2006-02-14 15:09:29 UTC (rev 1312)
@@ -15065,10 +15065,18 @@
</indexterm>
<indexterm type="function">
+ <primary>SHOW EVENTS</primary>
+ </indexterm>
+
+ <indexterm type="function">
<primary>SHOW CREATE DATABASE</primary>
</indexterm>
<indexterm type="function">
+ <primary>SHOW CREATE EVENT</primary>
+ </indexterm>
+
+ <indexterm type="function">
<primary>SHOW CREATE FUNCTION</primary>
</indexterm>
@@ -15085,6 +15093,10 @@
</indexterm>
<indexterm type="function">
+ <primary>SHOW CREATE VIEW</primary>
+ </indexterm>
+
+ <indexterm type="function">
<primary>SHOW DATABASES</primary>
</indexterm>
@@ -15200,13 +15212,16 @@
<programlisting>
SHOW [FULL] COLUMNS FROM <replaceable>tbl_name</replaceable> [FROM <replaceable>db_name</replaceable>] [LIKE '<replaceable>pattern</replaceable>']
SHOW CREATE DATABASE <replaceable>db_name</replaceable>
+SHOW CREATE EVENT <replaceable>event_name</replaceable>
SHOW CREATE FUNCTION <replaceable>funcname</replaceable>
SHOW CREATE PROCEDURE <replaceable>procname</replaceable>
SHOW CREATE TABLE <replaceable>tbl_name</replaceable>
+SHOW CREATE VIEW <replaceable>view_name</replaceable>
SHOW DATABASES [LIKE '<replaceable>pattern</replaceable>']
SHOW ENGINE <replaceable>engine_name</replaceable> {LOGS | STATUS }
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [<replaceable>offset</replaceable>,] <replaceable>row_count</replaceable>]
+SHOW [FULL] EVENTS
SHOW FUNCTION STATUS [LIKE '<replaceable>pattern</replaceable>']
SHOW GRANTS FOR <replaceable>user</replaceable>
SHOW INDEX FROM <replaceable>tbl_name</replaceable> [FROM <replaceable>db_name</replaceable>]
@@ -15679,7 +15694,50 @@
<remark role="help-description-end"/>
</section>
+
+ <section id="show-create-view">
+
+ <title>&title-show-create-view;</title>
+
+ <indexterm type="function">
+ <primary>SHOW CREATE VIEW</primary>
+ </indexterm>
+
+ <remark role="help-topic" condition="SHOW CREATE VIEW"/>
+
+ <remark role="help-syntax"/>
+
+<programlisting>
+SHOW CREATE VIEW <replaceable>view_name</replaceable>
+</programlisting>
+
+ <remark role="help-description-begin"/>
+
+ <para>
+ This statement shows a <literal>CREATE VIEW</literal> statement
+ that creates the given view.
+ </para>
+
+ <remark role="help-description-end"/>
+
+<programlisting>
+mysql> <userinput>SHOW CREATE VIEW v;</userinput>
++------+----------------------------------------------------+
+| View | Create View |
++------+----------------------------------------------------+
+| v | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
++------+----------------------------------------------------+
+</programlisting>
+
+ <para>
+ You can also obtain information about view objects from
+ <literal>INFORMATION_SCHEMA</literal>, which contains a
+ <literal>VIEWS</literal> table. See <xref linkend="views-table"/>.
+ </para>
+
+ </section>
+
<section id="show-databases">
<title>&title-show-databases;</title>
Modified: trunk/refman-5.1/views.xml
===================================================================
--- trunk/refman-5.1/views.xml 2006-02-14 14:37:57 UTC (rev 1311)
+++ trunk/refman-5.1/views.xml 2006-02-14 15:09:29 UTC (rev 1312)
@@ -43,13 +43,6 @@
</para>
</listitem>
- <listitem>
- <para>
- Displaying view metadata with <literal>SHOW CREATE
- VIEW</literal>
- </para>
- </listitem>
-
</itemizedlist>
<para>
@@ -63,6 +56,14 @@
grant tables so that they contain the view-related privileges. See
<xref linkend="mysql-fix-privilege-tables"/>.
</para>
+
+ <para>
+ Metadata about views can be obtained from the
+ <literal>INFORMATION_SCHEMA.VIEWS</literal> table and by using the
+ <literal>SHOW CREATE VIEW</literal> statement. See
+ <xref linkend="views-table"/> and
+ <xref linkend="show-create-view"/>.
+ </para>
<section id="alter-view">
@@ -1029,46 +1030,4 @@
</section>
- <section id="show-create-view">
-
- <title>&title-show-create-view;</title>
-
- <indexterm type="function">
- <primary>SHOW CREATE VIEW</primary>
- </indexterm>
-
- <remark role="help-topic" condition="SHOW CREATE VIEW"/>
-
- <remark role="help-syntax"/>
-
-<programlisting>
-SHOW CREATE VIEW <replaceable>view_name</replaceable>
-</programlisting>
-
- <remark role="help-description-begin"/>
-
- <para>
- This statement shows a <literal>CREATE VIEW</literal> statement
- that creates the given view.
- </para>
-
- <remark role="help-description-end"/>
-
-<programlisting>
-mysql> <userinput>SHOW CREATE VIEW v;</userinput>
-+------+----------------------------------------------------+
-| View | Create View |
-+------+----------------------------------------------------+
-| v | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
-+------+----------------------------------------------------+
-</programlisting>
-
- <para>
- You can also obtain information about view objects from
- <literal>INFORMATION_SCHEMA</literal>, which contains a
- <literal>VIEWS</literal> table. See <xref linkend="views-table"/>.
- </para>
-
- </section>
-
</chapter>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1312 - in trunk: refman-5.0 refman-5.1 | jon | 14 Feb |
