Author: jstephens
Date: 2007-04-22 07:29:43 +0200 (Sun, 22 Apr 2007)
New Revision: 6054
Log:
Updated getting-information from user comments.
Modified:
trunk/refman-4.1/tutorial.xml
trunk/refman-5.0/tutorial.xml
trunk/refman-5.1/tutorial.xml
Modified: trunk/refman-4.1/tutorial.xml
===================================================================
--- trunk/refman-4.1/tutorial.xml 2007-04-21 23:44:19 UTC (rev 6053)
+++ trunk/refman-4.1/tutorial.xml 2007-04-22 05:29:43 UTC (rev 6054)
Changed blocks: 2, Lines Added: 28, Lines Deleted: 3; 2150 bytes
@@ -2836,12 +2836,20 @@
<programlisting>
mysql> <userinput>SHOW TABLES;</userinput>
+---------------------+
-| Tables in menagerie |
+| Tables_in_menagerie |
+---------------------+
| event |
| pet |
+---------------------+
</programlisting>
+
+ <para>
+ The name of the column in the output produced by this statement is
+ always
+ <literal>Tables_in_<replaceable>db_name</replaceable></literal>,
+ where <replaceable>db_name</replaceable> is the name of the
+ database. See <xref linkend="show-tables"/>, for more information.
+ </para>
<para>
If you want to find out about the structure of a table, the
@@ -2869,13 +2877,30 @@
<literal>NULL</literal> indicates whether the column can contain
<literal>NULL</literal> values, <literal>Key</literal> indicates
whether the column is indexed, and <literal>Default</literal>
- specifies the column's default value.
+ specifies the column's default value. <literal>Extra</literal>
+ displays special information about columns; for example, if a
+ column was created with the <literal>AUTO_INCREMENT</literal>
+ option, this is shown here.
</para>
+
+ <para>
+ <literal>DESC</literal> is a short form of
+ <literal>DESCRIBE</literal>. See <xref linkend="describe"/>, for
+ more information.
+ </para>
+
+ <para>
+ You can obtain the <literal>CREATE TABLE</literal> statement
+ necessary to create an existing table using the <literal>SHOW
+ CREATE TABLE</literal> statement. See
+ <xref linkend="show-create-table"/>.
+ </para>
<para>
If you have indexes on a table, <literal>SHOW INDEX FROM
<replaceable>tbl_name</replaceable></literal> produces information
- about them.
+ about them. See <xref linkend="show-index"/>, for more about this
+ statement.
</para>
</section>
Modified: trunk/refman-5.0/tutorial.xml
===================================================================
--- trunk/refman-5.0/tutorial.xml 2007-04-21 23:44:19 UTC (rev 6053)
+++ trunk/refman-5.0/tutorial.xml 2007-04-22 05:29:43 UTC (rev 6054)
Changed blocks: 2, Lines Added: 30, Lines Deleted: 5; 2427 bytes
@@ -2822,12 +2822,20 @@
<programlisting>
mysql> <userinput>SHOW TABLES;</userinput>
+---------------------+
-| Tables in menagerie |
+| Tables_in_menagerie |
+---------------------+
| event |
| pet |
+---------------------+
</programlisting>
+
+ <para>
+ The name of the column in the output produced by this statement is
+ always
+ <literal>Tables_in_<replaceable>db_name</replaceable></literal>,
+ where <replaceable>db_name</replaceable> is the name of the
+ database. See <xref linkend="show-tables"/>, for more information.
+ </para>
<para>
If you want to find out about the structure of a table, the
@@ -2848,20 +2856,37 @@
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
</programlisting>
-
+
<para>
<literal>Field</literal> indicates the column name,
<literal>Type</literal> is the data type for the column,
<literal>NULL</literal> indicates whether the column can contain
<literal>NULL</literal> values, <literal>Key</literal> indicates
whether the column is indexed, and <literal>Default</literal>
- specifies the column's default value.
+ specifies the column's default value. <literal>Extra</literal>
+ displays special information about columns; for example, if a
+ column was created with the <literal>AUTO_INCREMENT</literal>
+ option, this is shown here.
</para>
-
+
<para>
+ <literal>DESC</literal> is a short form of
+ <literal>DESCRIBE</literal>. See <xref linkend="describe"/>, for
+ more information.
+ </para>
+
+ <para>
+ You can obtain the <literal>CREATE TABLE</literal> statement
+ necessary to create an existing table using the <literal>SHOW
+ CREATE TABLE</literal> statement. See
+ <xref linkend="show-create-table"/>.
+ </para>
+
+ <para>
If you have indexes on a table, <literal>SHOW INDEX FROM
<replaceable>tbl_name</replaceable></literal> produces information
- about them.
+ about them. See <xref linkend="show-index"/>, for more about this
+ statement.
</para>
</section>
Modified: trunk/refman-5.1/tutorial.xml
===================================================================
--- trunk/refman-5.1/tutorial.xml 2007-04-21 23:44:19 UTC (rev 6053)
+++ trunk/refman-5.1/tutorial.xml 2007-04-22 05:29:43 UTC (rev 6054)
Changed blocks: 2, Lines Added: 30, Lines Deleted: 5; 2425 bytes
@@ -2816,12 +2816,20 @@
<programlisting>
mysql> <userinput>SHOW TABLES;</userinput>
+---------------------+
-| Tables in menagerie |
+| Tables_in_menagerie |
+---------------------+
| event |
| pet |
+---------------------+
</programlisting>
+
+ <para>
+ The name of the column in the output produced by this statement is
+ always
+ <literal>Tables_in_<replaceable>db_name</replaceable></literal>,
+ where <replaceable>db_name</replaceable> is the name of the
+ database. See <xref linkend="show-tables"/>, for more information.
+ </para>
<para>
If you want to find out about the structure of a table, the
@@ -2842,20 +2850,37 @@
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
</programlisting>
-
+
<para>
<literal>Field</literal> indicates the column name,
<literal>Type</literal> is the data type for the column,
<literal>NULL</literal> indicates whether the column can contain
<literal>NULL</literal> values, <literal>Key</literal> indicates
whether the column is indexed, and <literal>Default</literal>
- specifies the column's default value.
+ specifies the column's default value. <literal>Extra</literal>
+ displays special information about columns; for example, if a
+ column was created with the <literal>AUTO_INCREMENT</literal>
+ option, this is shown here.
</para>
-
+
<para>
+ <literal>DESC</literal> is a short form of
+ <literal>DESCRIBE</literal>. See <xref linkend="describe"/>, for
+ more information.
+ </para>
+
+ <para>
+ You can obtain the <literal>CREATE TABLE</literal> statement
+ necessary to create an existing table using the <literal>SHOW
+ CREATE TABLE</literal> statement. See
+ <xref linkend="show-create-table"/>.
+ </para>
+
+ <para>
If you have indexes on a table, <literal>SHOW INDEX FROM
<replaceable>tbl_name</replaceable></literal> produces information
- about them.
+ about them. See <xref linkend="show-index"/>, for more about this
+ statement.
</para>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6054 - in trunk: refman-4.1 refman-5.0 refman-5.1 | jon | 22 Apr |
