INFORMATION_SCHEMA

Submitted by yejr on 周四, 2006/11/16 - 17:26

A.7. MySQL 5.0 FAQ — INFORMATION_SCHEMA

Questions

  • 26.7.1:
    在哪里能找到 INFORMATION_SCHEMA 数据库的文档?

    Where can I find documentation for the MySQL code>INFORMATION_SCHEMA database?

  • 26.7.2:
    哪里有关于 INFORMATION_SCHEMA 的讨论?

    Is there a discussion forum for INFORMATION_SCHEMA?

  • 26.7.3:
    哪里能找到 ANSI SQL 2003规范中关于 INFORMATION_SCHEMA 的部分?

    Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA?

  • 26.7.4:
    Oracle数据目录和MySQL的 INFORMATION_SCHEMA 区别在哪里?

    What is the difference between the Oracle Data Dictionary and MySQL's INFORMATION_SCHEMA?

  • 26.7.5:
    我能否往 INFORMATION_SCHEMA 数据库中增加/修改数据表?

    Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database?

Questions and Answers

26.7.1:
Where can I find documentation for the MySQL
INFORMATION_SCHEMA database?

详情请看 Chapter 20, The INFORMATION_SCHEMA Database.

See Chapter 20, The INFORMATION_SCHEMA Database

26.7.2:
Is there a discussion forum for
INFORMATION_SCHEMA?

详情请看 http://forums.mysql.com/list.php?101.

See
http://forums.mysql.com/list.php?101.

26.7.3:
Where can I find the ANSI SQL 2003 specification for
INFORMATION_SCHEMA?

很抱歉,官方的规范还不是免费的(ANSI 对此是收费的).尽管如此,市面上有些书 - 如 Peter Gulutzan 和 Trudy Pelzer 所著的 SQL-99 Complete, Really,全面讲述了该标准,也包括 INFORMATION_SCHEMA.

Unfortunately, the official specifications are not freely
available. (ANSI makes them available for purchase.)
However, there are books available — such as
SQL-99 Complete, Really by Peter
Gulutzan and Trudy Pelzer — which give a comprehensive
overview of the standard, including
INFORMATION_SCHEMA.

26.7.4:
What is the difference between the Oracle Data Dictionary
and MySQL's INFORMATION_SCHEMA?

Oracle和MySQL都在数据表中存储了元数据.不过,Oracle和MySQL使用了不同的数据表名和字段名,MySQL的实现方式和DB2以及SQL Server的相似,同时也支持SQL标准中的 INFORMATION_SCHEMA 定义.

Both Oracle and MySQL provide metadata in tables. However,
Oracle and MySQL use different table names and column names.
MySQL's implementation is more similar to those found in DB2
and SQL Server, which also support
INFORMATION_SCHEMA as defined in the SQL
standard.

26.7.5:
Can I add to or otherwise modify the tables found in the
INFORMATION_SCHEMA database?

不能.由于应用程序可能基于一定的标准结构之上,因此它们不能被修改.正是由于这个原因,MySQL AB不接受关于修改 INFORMATION_SCHEMA 中的数据表或者从中取得数据方面的问题的bug.

No. Since applications may rely on a certain standard
structure, this should not be modified. For this reason,
MySQL AB cannot support bugs or other issues which
result from modifying INFORMATION_SCHEMA
tables or data.

技术相关: