Author: paul
Date: 2006-02-18 19:20:36 +0100 (Sat, 18 Feb 2006)
New Revision: 1382
Log:
r7812@frost: paul | 2006-02-18 11:29:12 -0600
Revise intro, standardize table column headings.
Modified:
trunk/
trunk/refman-5.0/information-schema.xml
trunk/refman-5.1/information-schema.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7785
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3223
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7812
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3223
Modified: trunk/refman-5.0/information-schema.xml
===================================================================
--- trunk/refman-5.0/information-schema.xml 2006-02-18 05:33:09 UTC (rev 1381)
+++ trunk/refman-5.0/information-schema.xml 2006-02-18 18:20:36 UTC (rev 1382)
@@ -53,14 +53,25 @@
the place that stores information about all the other databases that
the MySQL server maintains. Inside
<literal>INFORMATION_SCHEMA</literal> there are several read-only
- tables. They are actually views, not base tables, so you will not
- actually see any file associated with them.
+ tables. They are actually views, not base tables, so there are no
+ files associated with them.
</para>
<para>
- Here is an example:
+ In effect, we have a database named
+ <literal>INFORMATION_SCHEMA</literal>, although the server does not
+ create a database directory with that name. It is possible to select
+ <literal>INFORMATION_SCHEMA</literal> as the default database with a
+ <literal>USE</literal> statement, but it is possible only to read
+ the contents of tables. You cannot insert into them, update them, or
+ delete from them.
</para>
+ <para>
+ Here is an example of a statement that retrieves information from
+ <literal>INFORMATION_SCHEMA</literal>:
+ </para>
+
<programlisting>
mysql> <userinput>SELECT table_name, table_type, engine</userinput>
-> <userinput>FROM information_schema.tables</userinput>
@@ -98,9 +109,9 @@
</para>
<para>
- Each MySQL user has the right to access these tables, but only the
- rows in the tables that correspond to objects for which the user has
- the proper access privileges.
+ Each MySQL user has the right to access these tables, but can see
+ only the rows in the tables that correspond to objects for which the
+ user has the proper access privileges.
</para>
<para>
@@ -157,8 +168,9 @@
employees and users, and because it might be confusing were it to
disappear, the advantages of conventional syntax are not a
sufficient reason to eliminate <literal>SHOW</literal>. In fact,
- there are enhancements to <literal>SHOW</literal> in MySQL
- ¤t-series; as well. These are described in
+ along with the implementation of
+ <literal>INFORMATION_SCHEMA</literal>, there are enhancements to
+ <literal>SHOW</literal> as well. These are described in
<xref linkend="extended-show"/>.
</para>
@@ -193,16 +205,6 @@
</para>
<para>
- In effect, we have a database named
- <literal>INFORMATION_SCHEMA</literal>, although the server does not
- create a database directory with that name. It is possible to select
- <literal>INFORMATION_SCHEMA</literal> as the default database with a
- <literal>USE</literal> statement, but it is possible only to read
- the contents of tables. You cannot insert into them, update them, or
- delete from them.
- </para>
-
- <para>
The following sections describe each of the tables and columns that
are in <literal>INFORMATION_SCHEMA</literal>. For each column, there
are three pieces of information:
@@ -212,16 +214,19 @@
<listitem>
<para>
- <quote>Standard Name</quote> indicates the standard SQL name for
- the column.
+ <quote><literal>INFORMATION_SCHEMA</literal> Name</quote>
+ indicates the name for the column in the
+ <literal>INFORMATION_SCHEMA</literal> table. This corresponds to
+ the standard SQL name unless the <quote>Remarks</quote> field
+ says <quote>MySQL extension.</quote>
</para>
</listitem>
<listitem>
<para>
- <quote><literal>SHOW</literal> name</quote> indicates what the
- equivalent field name is in the closest <literal>SHOW</literal>
- statement, if any.
+ <quote><literal>SHOW</literal> Name</quote> indicates the
+ equivalent field name in the closest <literal>SHOW</literal>
+ statement, if there is one.
</para>
</listitem>
@@ -230,6 +235,8 @@
<quote>Remarks</quote> provides additional information where
applicable. If this field is <literal>NULL</literal>, it means
that the value of the column is always <literal>NULL</literal>.
+ If this field says <quote>MySQL extension,</quote> the column is
+ a MySQL extension to standard SQL.
<remark>
We have marked ``omit'' those columns for which MySQL has no
@@ -244,7 +251,7 @@
<para>
To avoid using any name that is reserved in the standard or in DB2,
- SQL Server, or Oracle, we changed the names of columns marked
+ SQL Server, or Oracle, we changed the names of some columns marked
<quote>MySQL extension</quote>. (For example, we changed
<literal>COLLATION</literal> to <literal>TABLE_COLLATION</literal>
in the <literal>TABLES</literal> table.) See the list of reserved
@@ -293,8 +300,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -410,8 +418,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -676,8 +685,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1155,8 +1165,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1334,8 +1345,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1402,8 +1414,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1475,8 +1488,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -1579,8 +1593,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -1705,8 +1720,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -1862,8 +1878,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -2051,8 +2068,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -2136,8 +2154,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -2268,8 +2287,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -2471,8 +2491,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>mysql.proc</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>mysql.proc</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -2871,8 +2892,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -3036,8 +3058,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2006-02-18 05:33:09 UTC (rev 1381)
+++ trunk/refman-5.1/information-schema.xml 2006-02-18 18:20:36 UTC (rev 1382)
@@ -53,14 +53,25 @@
the place that stores information about all the other databases that
the MySQL server maintains. Inside
<literal>INFORMATION_SCHEMA</literal> there are several read-only
- tables. They are actually views, not base tables, so you will not
- actually see any file associated with them.
+ tables. They are actually views, not base tables, so there are no
+ files associated with them.
</para>
<para>
- Here is an example:
+ In effect, we have a database named
+ <literal>INFORMATION_SCHEMA</literal>, although the server does not
+ create a database directory with that name. It is possible to select
+ <literal>INFORMATION_SCHEMA</literal> as the default database with a
+ <literal>USE</literal> statement, but it is possible only to read
+ the contents of tables. You cannot insert into them, update them, or
+ delete from them.
</para>
+ <para>
+ Here is an example of a statement that retrieves information from
+ <literal>INFORMATION_SCHEMA</literal>:
+ </para>
+
<programlisting>
mysql> <userinput>SELECT table_name, table_type, engine</userinput>
-> <userinput>FROM information_schema.tables</userinput>
@@ -98,9 +109,9 @@
</para>
<para>
- Each MySQL user has the right to access these tables, but only the
- rows in the tables that correspond to objects for which the user has
- the proper access privileges.
+ Each MySQL user has the right to access these tables, but can see
+ only the rows in the tables that correspond to objects for which the
+ user has the proper access privileges.
</para>
<para>
@@ -157,8 +168,9 @@
employees and users, and because it might be confusing were it to
disappear, the advantages of conventional syntax are not a
sufficient reason to eliminate <literal>SHOW</literal>. In fact,
- there are enhancements to <literal>SHOW</literal> in MySQL
- ¤t-series; as well. These are described in
+ along with the implementation of
+ <literal>INFORMATION_SCHEMA</literal>, there are enhancements to
+ <literal>SHOW</literal> as well. These are described in
<xref linkend="extended-show"/>.
</para>
@@ -193,16 +205,6 @@
</para>
<para>
- In effect, we have a database named
- <literal>INFORMATION_SCHEMA</literal>, although the server does not
- create a database directory with that name. It is possible to select
- <literal>INFORMATION_SCHEMA</literal> as the default database with a
- <literal>USE</literal> statement, but it is possible only to read
- the contents of tables. You cannot insert into them, update them, or
- delete from them.
- </para>
-
- <para>
The following sections describe each of the tables and columns that
are in <literal>INFORMATION_SCHEMA</literal>. For each column, there
are three pieces of information:
@@ -212,16 +214,19 @@
<listitem>
<para>
- <quote>Standard Name</quote> indicates the standard SQL name for
- the column.
+ <quote><literal>INFORMATION_SCHEMA</literal> Name</quote>
+ indicates the name for the column in the
+ <literal>INFORMATION_SCHEMA</literal> table. This corresponds to
+ the standard SQL name unless the <quote>Remarks</quote> field
+ says <quote>MySQL extension.</quote>
</para>
</listitem>
<listitem>
<para>
- <quote><literal>SHOW</literal> name</quote> indicates what the
- equivalent field name is in the closest <literal>SHOW</literal>
- statement, if any.
+ <quote><literal>SHOW</literal> Name</quote> indicates the
+ equivalent field name in the closest <literal>SHOW</literal>
+ statement, if there is one.
</para>
</listitem>
@@ -230,6 +235,8 @@
<quote>Remarks</quote> provides additional information where
applicable. If this field is <literal>NULL</literal>, it means
that the value of the column is always <literal>NULL</literal>.
+ If this field says <quote>MySQL extension,</quote> the column is
+ a MySQL extension to standard SQL.
<remark>
We have marked ``omit'' those columns for which MySQL has no
@@ -244,7 +251,7 @@
<para>
To avoid using any name that is reserved in the standard or in DB2,
- SQL Server, or Oracle, we changed the names of columns marked
+ SQL Server, or Oracle, we changed the names of some columns marked
<quote>MySQL extension</quote>. (For example, we changed
<literal>COLLATION</literal> to <literal>TABLE_COLLATION</literal>
in the <literal>TABLES</literal> table.) See the list of reserved
@@ -293,8 +300,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -395,8 +403,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -661,8 +670,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1140,8 +1150,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1319,8 +1330,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1387,8 +1399,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -1460,8 +1473,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -1564,8 +1578,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -1690,8 +1705,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -1847,8 +1863,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -2036,8 +2053,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -2121,8 +2139,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -2253,8 +2272,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -2447,8 +2467,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>mysql.proc</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>mysql.proc</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<!--
@@ -2847,8 +2868,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -3010,8 +3032,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Standard Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -3287,8 +3310,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -3381,8 +3405,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -3460,8 +3485,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -3648,8 +3674,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
@@ -4043,8 +4070,9 @@
<colspec colwidth="30*"/>
<tbody>
<row>
- <entry><emphasis role="bold">Name</emphasis></entry>
- <entry><emphasis role="bold"><literal>SHOW</literal> name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>INFORMATION_SCHEMA</literal>
+ Name</emphasis></entry>
+ <entry><emphasis role="bold"><literal>SHOW</literal> Name</emphasis></entry>
<entry><emphasis role="bold">Remarks</emphasis></entry>
</row>
<row>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1382 - in trunk: . refman-5.0 refman-5.1 | paul | 18 Feb |
