<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    252 MySQL Technical Reference for Version 4.0.3 The DESCRIBE statement provides information similar to SHOW COLUMNS.  See Section 6.6.2 [DESCRIBE], page 482. SHOW FIELDS is a synonym for SHOW COLUMNS, and SHOW KEYS is a synonym for SHOW INDEX. You  can  also  list  a  table's  columns  or  indexes  with  mysqlshow db_name tbl_name  or mysqlshow -k db_name tbl_name. SHOW INDEX returns the index information in a format that closely resembles the SQLStatistics call in ODBC. The following columns are returned: Column Meaning Table Name of the table. Non_unique 0 if the index can't contain duplicates. Key_name Name of the index. Seq_in_ index Column  sequence  number  in  index,   starting with 1. Column_name Column name. Collation How  the  column  is  sorted  in  the  index.    In MySQL,  this  can  have  values  `A'  (Ascending) or NULL (Not sorted). Cardinality Number of unique values in the index.  This is updated by running isamchk -a. Sub_part Number of indexed characters if the column is only  partly  indexed.   NULL  if  the  entire  key  is indexed. Null Contains 'YES' if the column may contain NULL. Index_type Index method used. Comment Various remarks.  For now, it tells in MySQL < 4.0.2 whether index is FULLTEXT or not. Note  that  as  the  Cardinality  is  counted  based  on  statistics  stored  as  integers,  it's  not necessarily accurate for small tables. The Null and Index_type columns were added in MySQL 4.0.2. 4.5.6.2  SHOW TABLE STATUS SHOW TABLE STATUS [FROM db_name] [LIKE wild] SHOW TABLE STATUS  (new in Version 3.23) works likes  SHOW STATUS, but provides a lot of information  about  each  table.   You  can  also  get  this  list  using  the  mysqlshow --status db_name command.  The following columns are returned: Column Meaning Name Name of the table. Type Type of table.  See Chapter 7 [Table types], page 494. Row_format The row storage format (Fixed, Dynamic, or Compressed). Rows Number of rows. Avg_row_length Average row length. Data_length Length of the data le. Max_data_length Max length of the data le.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide