The
INFORMATION_SCHEMA TABLES
Table
1724
INFORMATION_SCHEMA
Name
SHOW
Name
Remarks
TABLE_SCHEMA
= Database
TABLE_NAME
Table
NON_UNIQUE
Non_unique
INDEX_SCHEMA
= Database
INDEX_NAME
Key_name
SEQ_IN_INDEX
Seq_in_index
COLUMN_NAME
Column_name
COLLATION
Collation
CARDINALITY
Cardinality
SUB_PART
Sub_part
MySQL extension
PACKED
Packed
MySQL extension
NULLABLE
Null
MySQL extension
INDEX_TYPE
Index_type
MySQL extension
COMMENT
Comment
MySQL extension
Notes:
• There is no standard table for indexes. The preceding list is similar to what SQL Server 2000 returns
for
sp_statistics
, except that we replaced the name
QUALIFIER
with
CATALOG
and we replaced
the name
OWNER
with
SCHEMA
.
Clearly, the preceding table and the output from
SHOW INDEX
are derived from the same parent. So
the correlation is already close.
The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.STATISTICS
WHERE table_name = '
tbl_name
'
AND table_schema = '
db_name
'
SHOW INDEX
FROM
tbl_name
FROM
db_name
19.12. The
INFORMATION_SCHEMA TABLES
Table
The
TABLES
table provides information about tables in databases.
INFORMATION_SCHEMA
Name
SHOW
Name
Remarks
TABLE_CATALOG
NULL
TABLE_SCHEMA
Table_
...
TABLE_NAME
Table_
...
TABLE_TYPE
ENGINE
Engine
MySQL extension
VERSION
Version
The version number of the
table's
.frm
file, MySQL
extension
ROW_FORMAT
Row_format
MySQL extension
TABLE_ROWS
Rows
MySQL extension
AVG_ROW_LENGTH
Avg_row_length
MySQL extension
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...